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.
Bookmarks