select a range using "cells()"

F

fullers

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
 
B

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.
 
A

Alan Beban

Bob said:
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 ...
Click to expand...
Set rng = Range("A1")
Range(rng(1,1),rng(6,2)).Select

Alan Beban
 
Top