As part of a called module action, I need to be able to call a single equation stored in a cell to be placed in multiple cells down a column corresponding to a value that is placed in the cel prior to it. As a practice, I stored the equation "=G2*2" in cell H2.

My code to call this equation in the column D is as follows.

I was getting a #Ref due to other aspects of the code. I have since remedied that.

[Edit] The current issue is that the formula is not updating down the column, ie. each formula references "G2" rather than the cell next to it like I had planned. I expected the formula would work as a copy and paste operation in Excel would cause.

Thanks

My code to call this equation in the column D is as follows.

Code:

` Range("D" & j + 1).Value = Sheets("Data Input").Range("H2").Formula`

I was getting a #Ref due to other aspects of the code. I have since remedied that.

[Edit] The current issue is that the formula is not updating down the column, ie. each formula references "G2" rather than the cell next to it like I had planned. I expected the formula would work as a copy and paste operation in Excel would cause.

Thanks

Last edited: