Hello,

I am simply trying to figure out how many rows of information exists i
my spreadsheet, but I've googled and googled and I can't find th
correct syntax for the code.

Basically. I am starting at like cell A5 and then I just want to coun
how many rows of below it (like cell A6, A7) have information in them.
And the code should stop immediately when a cell is empty.

Anyone know the syntax for the code like this

--
FC
-----------------------------------------------------------------------
FCC's Profile: http://www.excelforum.com/member.php...fo&userid=3588
View this thread: http://www.excelforum.com/showthread.php?threadid=55721