convert formula to vba
"JLGWhiz" schreef in bericht
...
What moon gave you will work but it seems easier to use:
ActiveSheet.Cells(2,1).Formula = "=CONCATENATE(""Text"",C2)"
I never understood the need of =CONCATENATE anyway, since strings can easily
be concatenated with the &:
ActiveSheet.Cells(2,1).Value = "Text" & ActiveSheet.Cells(2,3).Value
|