Bob's example will find the end of range provided, as he pointed out,
there are are no blank lines with in the range. This is a good approach
if you know where your range starts.

Dave's example is commonly used to find the last cell within in a
column. This is not the same as Bob's example as you can have multiple
ranges within a column with each separated by one or more blank lines.


Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=514205