Thread: How to know whether sheet1 contains any data in it?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
kvenku[_31_] kvenku[_31_] is offline
external usenet poster
  
Posts: 1
Default How to know whether sheet1 contains any data in it?
Hi,
I have a VBA application where i need to know that sheets1 contain
any data on it

I tried this and this take a long time to execute..Can you help me out


For StrRow = 1 To Rows.Count
For StrCol = 1 To Columns.Count
If Len(Cells(StrCol, StrRow).Value) 0 Then
MsgBox "Found"
Exit Sub
End If
Next
Nex

--
Message posted from http://www.ExcelForum.com

Reply With QuoteReply With Quote