select a range using "cells()"
 

Rather than using the range function to select multiple cells, ie:

Range("A1:B6").Select

Is there a way to use - Cells() instead. This is because the number of cells
will change.

Thanks

Range(Cells(1,1),Cells(6,2)).Select

or

Range(Cells(1,"A"),Cells(6,"B").Select

or

Cells(1,"A").Resize(6,2).Select

or ...

etc.

--
HTH

Bob Phillips

"fullers" wrote in message
...
Rather than using the range function to select multiple cells, ie:

Range("A1:B6").Select

Is there a way to use - Cells() instead. This is because the number of
cells
will change.

Thanks

Bob Phillips wrote:
Range(Cells(1,1),Cells(6,2)).Select

or

Range(Cells(1,"A"),Cells(6,"B").Select

or

Cells(1,"A").Resize(6,2).Select

or ...

Set rng = Range("A1")
Range(rng(1,1),rng(6,2)).Select

Alan Beban