[ShiamakD]

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