Cells function attribute .resize

Copper Contributor

I found this line that works

v1 = Range("J10")                                 [eg J10 = 6]
Row = 10 - v1 - 1                                  [Row = 3]
v = [{0;1;2;3;4;5;6;7;""}]
Cells(Row, 10).Resize(9, 1) = v

It alters the contents of cells in column 10 from rows 4 to 11 to 'jump' up 1 cell.

My question is how can I find out more about the .resize(9,1) attributes: what they mean or do?

The Excel help is useless for this...

1 Reply

@clonemonkey  I'm no expert on this but I believe .resize just changes the range selection.

So in your example you start with a single cell then resize it to be 9 rows high by 1 column wide so the range selection went from cell J3 to a range j3:j11 and then you assign that array to that range of cells.