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?

Dim rng As Range, LastRow As Long
LastRow = Cells(Rows.Count, "B").End(xlUp).Row
Set rng = Range("A1:B"& LastRow)

Mike F
"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?

Range("A1:B" & Range("B1").End(xlDown).Row)



--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Simon" wrote:

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?

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?

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?

On Jul 28, 11:43*am, JMay wrote:
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?- Hide quoted text -

- Show quoted text -

Yes, thansk the ,2) was requred, specifing the number of rows required.