lyp_sj


I assigned a formula to Range(D2Big Smile10), but I cann't see the formula result in the spreadsheet, what I can do is only show the result by using msgbox. So how can I show my formula result in the spreadsheet Thanks so much!

Private Sub CommandButton1_Click()
Worksheets("MMS_RSP_Tonnes").Range("D2Big Smile10").FormulaR1C1 = "=MMS_RSP_GSV!R[0]C[0]*1000/GSVperTonne!R[0]C[0]"
Dim A As Variant
A = Worksheets("MMS_RSP_Tonnes").Range("D4").Value
MsgBox A
End Sub





Re: How can I show the formula result in my cells?

Andy Pope


Hi,

Does the formula get placed in the cells on MMS_RSP_Tonnes

When I construct a simple test your code works fine.






Re: How can I show the formula result in my cells?

lyp_sj

Hello, thanks so much! I tried again, it did work. I do not what happened last time. Anyway, thx so much!