Select Range??
Posted by mike on July 21, 2000 5:54 AM
I am at cell x(variable) which is in column A, I want to select all the cells above to cell A2.
THANKS
Posted by Ada on July 21, 0100 6:21 AM
Mike
Includ1ng cell x :-
Range("A2:" & x.Address).Select
Not including cell x :-
Range("A2:" & x.Offset(-1, 0).Address).Select
Ada
Posted by mike on July 21, 0100 6:53 AM
Works THanks!!
