Adding multiples lines to a Macros value using VB
 

Hi,

Is there a way to add multiple lines value to a macro using VB??

e.g to Application.Macros(vbldMacroTemporary).Add "NAME",

I would like to add

Abc def
ghi jkl
mno qrs

etc?

I dont want one line string rather have the values like it is displayed in the example above.

TIA

"Abc def" & vbCrLf & "ghi jkl" & vbCrLf & "mno qrs"

Thanks so much for prompt and accurate response.


Keep up the good work!

Thanks again!