I would like my macro to look for the first empty line and use that as
the secdond range value. So for example,

Do while ActiveCell< empty
activecell.offset(1,0).Select
loop
Range("A3:activecell.offset(-1,0)").select


The problem is activecell.offset(-1,0) doesn't appear to be a valid
Range argument.


--
evil baby
------------------------------------------------------------------------
evil baby's Profile: http://www.excelforum.com/member.php...o&userid=31983
View this thread: http://www.excelforum.com/showthread...hreadid=519719