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
Barrie
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
neo
