How to Fit Any Formula in Formula Line in VBA

[Prasad K]

how can i fit any type of formula in formula line in vba code

here i have applied simple vba to apply formula based on cell selection from running vba macro and it's working perfectly when i placing formula into formulaR1C1 and here what i want how can apply only formula to formula line code without converting formula to formulaR1C1

here what the problem is when i placing only formula in formula line of code of vba then that line of code is changed to red color

Sub Multi()
    Dim Formula As String
    
    Formula = "=VALUE(LEFT(G10,FIND(" ",G10))*VALUE(LEFT(H10,FIND(" ",H10)-1)))"
    
    With Selection
        .Formula = Formula
        .Value = .Value
    End With
End Sub

 

[Peter_SSs]

Peter I said Thank you for how to write Formula in VBA line

This looked quite different to me

i don't know how to fit formula within double the quote marks in VBA

Anyway, so so as you are sorted now.