OK, here comes another question to follow up from the previous one.

If you write a macro and you need to specify a range of cells that
might change between different files, can you actually specify a range
that goes from your starting cell to the "end" (last nonblank cell in
range)?

George


--
GMB_Excel
------------------------------------------------------------------------
GMB_Excel's Profile: http://www.excelforum.com/member.php...o&userid=32141
View this thread: http://www.excelforum.com/showthread...hreadid=518979