select a range using "cells()"

[Guest]

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]

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.

 

[Alan Beban]

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