Range using indices

[Alan Beban]

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

Alan Beban

 

[Terry Bell]

I want to select a group of 4 adjacent cells in a for-next loop and
reference them using indices. If they were fixed cells I would use
Range("A11").Select.
If it was a single cell I could use Cells(m,n).Select. But how do I
use this notation to select a group of 4 cells in a row?
Brian.

 

[Daniel.M]

Hi Terry,

Cells(m,n).Resize(4,1)

Regards,

Daniel M.