Convert excel formula to vba

[billmark]

Hi
I have formula that works in excel but doesn't work in vba.

Formula: =A2 & " - " &D2

VBA:

With .Range("AC2:AC" & lr)[FONT=&quot] .Formula = "=A2 & " - " &D2"[/FONT]
[FONT=&quot] .Value = .Value[/FONT]
[FONT=&quot] End With

It gives me error - Run Time Error, Type Mismatch

Please help how to fix

Regards
Bill[/FONT]

 

[Michael M]

Try

With Range("AC2:AC" & lr)
    .Formula = "=A2 & "" - "" & D2"
    .Value = .Value
End With