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).Select


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Simon" <(E-Mail Removed)> wrote in message
news:ca47a142-5c85-4fef-bb4e-(E-Mail Removed)...
> 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).Select
>
>
> --
> HTH
>
> Bob
>
> (there's no email, no snail mail, but somewhere should be gmail in my addy)
>
> "Simon" <(E-Mail Removed)> wrote in message
> news:ca47a142-5c85-4fef-bb4e-(E-Mail Removed)...
> > 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 <J...@discussions.microsoft.com> 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).Select
>
> > --
> > HTH
>
> > Bob
>
> > (there's no email, no snail mail, but somewhere should be gmail in my addy)
>
> > "Simon" <simonlaven...@gmail.com> wrote in message
> >news:ca47a142-5c85-4fef-bb4e-(E-Mail Removed)...
> > > 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.