Another Cell reference question

[tmattioli]

Hi,
I currently have this line of code in my VBA application:

Sheet2.Cells(row, 20).Formula = "=(Round( (RC[-3] /" & Sheet2.Cells(4, 10) & "),2))*100"

This produces:

=(ROUND( (Q12 /17.005),2))*100

I would like to replace the "Sheet2.Cells(4,10)" that places the value in the formula with the actual cell Reference (J4). I'm sure this is a very easy thing to do but for the life of me I can't figure it out. As you can tell I'm a newbie to VBA. Thanks in advance for your help.

Tony

 

[mirabeau]

run this as a one-liner in a test vba code and see if it helps

MsgBox Cells(4, 10).Address(0, 0)

 

[tmattioli]

Thanks for the help. This does create an address but it's the same problem as with everything else I've tried in that it creates the following in the cell:

=(ROUND( (K13 /'J4'),2))*100

Everything I've tried puts those quote marks around the address.

Tony