Insert formula multiple times using a variable set in a cell

[tls123]

This is my first post. I'm just a novice using VBA so I constantly look for help on this board.

I want to use VBA to insert a formula (for ease, let's say it's simply "=D2") several times in column A and the number of times is determined by a value in another cell (e.g. C1). Then below that list, insert another formula ("=D3") the same number of times.

Any help would be greatly appreciated.

 

[bbott]

Welcome to the board.

Depending on whether or not you want your formula to use absolute references, try each of these:

Sub FrmColA()
    
    Range("A1:A" & Range("C1").Value).Formula = "=D2"
    Range("A" & Range("C1").Value + 1 & ":A" & Range("C1").Value * 2).Formula = "=D3"

End Sub

Sub FrmColA2()

Range("A1:A" & Range("C1").Value).Formula = "=$D$2"
Range("A" & Range("C1").Value + 1 & ":A" & Range("C1").Value * 2).Formula = "=$D$3"

End Sub

 

[tls123]

Perfect!! Thanks much

 

[bbott]

Perfect!! Thanks much

You're welcome.