A
Alan Beban
Set rng = Range("A1")
Range(rng(1, 1), rng(1, 4)).Select
Alan Beban
Range(rng(1, 1), rng(1, 4)).Select
Alan Beban
T
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("A1
1").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.
reference them using indices. If they were fixed cells I would use
Range("A1
1").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.
D
Daniel.M
Hi Terry,
Cells(m,n).Resize(4,1)
Regards,
Daniel M.
Cells(m,n).Resize(4,1)
Regards,
Daniel M.