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