Inserted formula with VBA containing ''

[mindsitch]

Hi, I am trying to insert a dynamic formula but for a reason I can't figure out in excel I get '' around the cell name. I have tried changing the cell format, variable type, making a separate variable and inserting as a whole. When I Debug.Print it shows normal. Any help would be great, I'll leave the code below. Thank you.

Range("H"&insertCell).Formula = "=G" & insertCell & "*R4C11"

insertCell is an Integer being passed from another Sub and it's a possible range of numbers between 10-100
The result in the formula bar is : ='G17'*$K$4
I will also mention that the row is being created and after the formula is inserted along with other data.

 

[Fluff]

Hi & welcome to MrExcel.
You are mixing A1 & R1C1 notation, which you shouldn't do. Try

Range("H" & insertCell).FormulaR1C1 = "=R" & insertCell & "C7*R4C11"

 

[mindsitch]

Hi & welcome to MrExcel.
You are mixing A1 & R1C1 notation, which you shouldn't do. Try

Range("H" & insertCell).FormulaR1C1 = "=R" & insertCell & "C7*R4C11"

omg that worked, thank you a lot

 

[Fluff]

You're welcome & thanks for the feedback.