I am trying to place a formula in a variable cell using referances that are also variable. Here is what I have so far:
Dim ShrCst As String
rownum is a previously set variable.
My problem is that it is outputing the value of the cells (ex. Cells(rownum,6) ). I need it to output the referance like F7.
Thanks in advance for any help
Dim ShrCst As String
Code:
ShrCst = "=" & Cells(rownum, 6) & "/" & Cells(rownum, 4) & "*100" ActiveSheet.Cells(rownum, 5) = ShrCst
My problem is that it is outputing the value of the cells (ex. Cells(rownum,6) ). I need it to output the referance like F7.
Thanks in advance for any help
Comment