Check to see if sheet is not empty - VBA

[goradiar]

I have this to check to see if the sheet is empty but how do I do the opposite? The reason why I'm asking is because I want to run some block of code if the sheet is not empty...

If WorksheetFunction.CountA(Cells) = 0 Then
  MsgBox "sheet is empty"
   
End If

Thank you!

 

[pplstuff]

Change
=
to
<>

 

[Rick Rothstein]

I have this to check to see if the sheet is empty but how do I do the opposite? The reason why I'm asking is because I want to run some block of code if the sheet is not empty...

If WorksheetFunction.CountA(Cells) = 0 Then
  MsgBox "sheet is empty"
   
End If

Thank you!

Well, if equaling zero shows you a sheet is empty, then testing if COUNTA is greater than zero should tell you if one or more cells contain something, correct?

If WorksheetFunction.CountA(Cells) > 0 Then
  MsgBox "Sheet is not empty
End If