Programming Comments from the inside!! Asistance Please
 

Hi Everyone!
I'm having a little problem programming comments. I use a database in
Microsoft Excel 2003 with a lot of comments. I coded a macro to insert
comments in some cells with a standard text heading and some variable
information get from a list of cells. The problem is the following: I
want to have the first line of text bold and black. the rest of the
text inside the comment i want to have it without the bold but in red
color. I have nearly 800 comments. I haven't formatted the text
manually coz i'll never end. Can you help me please?

Is like to have this inside a comment but without doing it manually
(The Record Macro function do not do the trick)
HEADING 1
Variable Text 1

All this inside a comment.

Thanks a lot
Alejandro C.


--
tristandelsur
------------------------------------------------------------------------
tristandelsur's Profile: http://www.excelforum.com/member.php...o&userid=27796
View this thread: http://www.excelforum.com/showthread...hreadid=473026