Could someone help me please with a problem inserting multi-line text from the VBE into a comment object on a worksheet.
Excel 2003
Windows XP
Please proceed to the text statement below for description of the problem.
With Sheets("Sheet27").Range("A10").AddComment .Text "This is text that should be inserted into a comment. _
Trouble is the vba editor wont accept these "space underscores" _
which i use normally to break up my code for easier reading. What _
is going wrong? I can see its got something to do with the quote marks _
but i need the quote marks for the comment text to work. It doesnt like _
putting text in quotes on each line and using an ampesand (&) to string together."
End With
Many thanks team VBA.
Regards
Peter
End With
I get a compile error and the text turns red.
What am i doing wrong and where could i have found the solution for myself without going to the microsoft forum
Regards
Peter