Macro for autofilling based on cell value

[CHagen]

Hey first time poster and new to VBA. I am trying to get the macro to run an auto fill of a series from 0-x from say,...cell i3 to i(x+3). Make sense? x being the value in a particular cell say,....cell b2. The value in b2 is user defined and can be changed, but I want changing this to automatically update the fill range... can you help?

[mrice]

Maybe you could post a workbook example with a before and after to illustrate your question.

[wallyeye]

You can actually just fill the entire range with the same formula at one shot, Excel will adjust the formula as per relative/absolute references:

Please Login or Register  to view this content.

or whatever your formula is. If you want the value in B2 to drive the length of the formula, you could use the worksheet_change event:

Please Login or Register  to view this content.

Just pay attention to the absolute/relative referencing in your formula. Here, cell B3 is locked in, A3 will vary with the position of the formula.

Edit:


Hmmmm...

If you decrease the value in B2, you might want to drop the trailing formulas:

Please Login or Register  to view this content.

Put this right after the "ActiveSheet... =" line.