View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Testing for an empty worksheet

If the cells in a worksheet contained only Comments, would you consider it
empty?
If a worksheet contained only embedded Objects, would you consider it empty?

--
Gary''s Student - gsnu200810


"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