Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Simplest way to check for a blank worksheet in an excel workbook

  Asked By: Navin    Date: Oct 21    Category: MS Office    Views: 866
  


What would be simplest way to check whether a worksheet is empty/blank
in an excel workbook.

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Wilfred Young     Answered On: Oct 21

Sub CheckMT()
Dim int1 As Integer
int1 = Application.CountA(ActiveSheet.UsedRange)
End Sub

 




Tagged: