I am creating an excel file programatically. Assume I added 10 rows.
I need to write VBA code to see the count of rows in the excel file.
How do I get this. There is a hidden list in the excel file with 500
rows or so. I do not want the count to reflect these rows. I only want
the count for the 10 rows that I added. how is it done? Would having
hidden rows for validation make a difference to the count of rows?


--
kpriyac
------------------------------------------------------------------------
kpriyac's Profile: http://www.excelforum.com/member.php...o&userid=37535
View this thread: http://www.excelforum.com/showthread...hreadid=573206