Hi,
Could any help me out?

I have a VBA application where i need to know the number of records i
the sheet1. Example if
1ts row = A
2nd row = b
3rd row = empty
4 th row =empty
5th row = p

then i should get 5 as the record count. Currently i am checking al
the rows one by one which is taking long time to get the result.

Also i need to know if any of the rows between 1 to 5 is empty then
need a message box to be displayed. Is there any function to get th
no. of rows and number of empty rows

for example

No of rows = 5
and No of empty rows = 2

Thanks in advance

Regards
Venkates

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