Jun 04 2020 06:31 PM
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...
Jun 04 2020 07:13 PM
@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.