Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range issue
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range issue
It will be a valid argument if you don't use it as a string - text.
Try this: Range("A3", ActiveCell.Offset(-1, 0)).Select good luck, Excel_Fun evil baby napisal(a): 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range issue
Don't bother with it, use this instead
Do While ActiveCell.Offset(1, 0) < Empty ActiveCell.Offset(1, 0).Select Loop -- HTH Bob Phillips (remove nothere from email address if mailing direct) "evil baby" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range issue
Thanks for the help, didn't even bother to look at where I had the quotes. -- 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I feel so dumb - please help - this is a Range issue | Excel Worksheet Functions | |||
Range issue... | Excel Programming | |||
Names.Add - Range Syntax Issue | Excel Programming | |||
Copy Range Issue | Excel Programming | |||
Excel Range issue | Excel Programming |