software

Hello, I am currently making a budget report using excel. I wish to use
quot;commentsquot; to justify various expenses. I would like the option of
printing them and understand how to do that, however, when i do, Excel
puts quot;cell a5 - quot;commentquot;quot; instead of what was actually in the cell,
making referencing them very difficult.

Is there any way to change the cell name when printing comments?

Thanks!!--
Amadis
------------------------------------------------------------------------
Amadis's Profile: www.excelforum.com/member.php...oamp;userid=31831
View this thread: www.excelforum.com/showthread...hreadid=515546Not built in.

But Debra Dalgleish has some code that copies the comments to another worksheet:
contextures.com/xlcomments03.html#CopyToSheet

You could add as much as you want to that routine.

If you're new to macros, you may want to read David McRitchie's intro at:
www.mvps.org/dmcritchie/excel/getstarted.htm

Amadis wrote:
gt;
gt; Hello, I am currently making a budget report using excel. I wish to use
gt; quot;commentsquot; to justify various expenses. I would like the option of
gt; printing them and understand how to do that, however, when i do, Excel
gt; puts quot;cell a5 - quot;commentquot;quot; instead of what was actually in the cell,
gt; making referencing them very difficult.
gt;
gt; Is there any way to change the cell name when printing comments?
gt;
gt; Thanks!!
gt;
gt; --
gt; Amadis
gt; ------------------------------------------------------------------------
gt; Amadis's Profile: www.excelforum.com/member.php...oamp;userid=31831
gt; View this thread: www.excelforum.com/showthread...hreadid=515546

--

Dave Peterson