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