Thread: Need to test for a blank worksheet.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Greg Glynn Greg Glynn is offline
external usenet poster
  
Posts: 137
Default Need to test for a blank worksheet.
Hi Everyone,

What can I use to test if a sheet is completely blank?

UsedRange.Rows.Count doesn't work because it yields an answer of "1"
even for a newly created sheet.

Any help would be appreciated.

Regards


Greg

Reply With QuoteReply With Quote