A1:B(xlDown)?
Needed to use
Range("A1").Resize(Range("B1").End(xlDown).Row, 2).Select
"Bob Phillips" wrote:
Range("A1").Resize(Range("A1").End(xlDown).Row).Se lect
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"Simon" wrote in message
...
Hi,
I use
Range("A1").Select
Range(Selection, Selection.End(xlDown)).Select
for column A, but how do I grab from A1 to the last record in row B in
one swoop?
|