Hi Neil,

One way. I am interested if anyone has other options.

If WorksheetFunction.CountA(Cells()) = 0 Then
MsgBox "Worksheet is empty"
Else
MsgBox "worksheet is not empty"
End If


--
Regards,

OssieMac


"Highlystrung" wrote:

What is the best way to test for an empty worksheet? I have been using a
count on rows and capturing the error but I assume there is a much simpler
way to do it?
--
thanks, Neil