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.
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.
VBA Code:
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.