how to select multiple cells and move the selection into a '

[jonybegood]

Hi,

I have a problem I haven't been able to solve:
how to select multiple cells (not contiguous)
and increment to the bottom the selection to keep only one row ?
here is the example:
range(B2:D2,B10:D10,B18:D18)
I want to make an increment like that:
range(B3:D3,B11:D11,B19:D19)
range(B4:D4,B12:D12,B20:D20)
..........
but automatically

thank you for your help
This message was edited by jonybegood on 2003-01-22 06:14

 

[Legacy 12630]

If you turn on the macro recorder and hold down the Ctrl key while selecting cells B2:D2,B10:D10,and B18:D18, what code do you get?