MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Using ActiveCell address as part of range

Posted by Barry Ward on August 15, 2001 7:53 AM

Can I use the address of the active cell in conjucntion with another named cell?

eg Range(ActiveCell.address & ([f2])).Select

Posted by Barrie Davidson on August 15, 2001 8:08 AM

Yes, the syntax is:

Range(ActiveCell.Address & ":F2").Select

PS - Why do you spell your name wrong? :)

Posted by Barry Ward on August 15, 2001 8:13 AM

Thank you, Thank you, Thank you...............

You're a star :)

Posted by neo on August 15, 2001 8:16 AM

if you rearange your formula a little it'll work :

Range("f2:" & ActiveCell.address).Select

or if the 'f2' is a named cell, it works the same :

Range("eftwo:" & ActiveCell.address).Select