Hi
I have an excel sheet where I want to fill down the rows in a column with VBA, using offset and the range between two other cell values.
To exemplify;
1) I want to fill out the E-column. It has to be filled with values in the range between the values in C2 and D2.
So if the value in C2 is 1 and D2 is 20, E has to be filled 20 rows down, with sequential numbers.
2) Furthermore, I want to be able to use the macro on multiple columns. So instead of having to specify i.e. C2 and D2, I want to use offset.
So E is filled with values between C2 and D2, F is filled with values between D2 and E2, etc.
The only code I have gotten to work with offset, is one where the value filled in is static (so I have to specify e.g. value = 1, instead of using a cell reference)
I have no idea how to make all this work.
I hope someone can help, let me know if you need more info.
Thanks
Bookmarks