Converting Formula to Values in VBA

[MacroMarko]

Hello,

I've got a formula in A1 that I want to convert to values in A2. Seems like this is something I have to do with VBA, but I don't know anything about VBA.

Care to donate a script I can use in VBA to do this? I'll do the googling to figure out how to add the script to VBA if you'd be so kind.

Thanks, Marko

 

[jproffer]

You can copy A1 and Paste Special...Values in A2. But in VBA it would be:

Sub MyPasteSpecial
Range("A2").Value = Range("A1").Value
End Sub