Printing comments using a named range as cell name

[Capybara]

Instead of using column/row references in printing
comments, I want the comments to use named ranges.

Printed comments now look like this:
Cell: A1
Comment: The Senate Labor Relations hearing will include
discussion of AB 3018.

I want the printed comment (at the back of the worksheet)
to look like this:

Cell: April13
Comment: The Senate Labor Relations hearing will include
discussion of AB 3018.

How do I do that?

 

[Jim Rech]

Excel does not have an option such as you described. The only workaround
that I can think of it to write a macro that places the cell comments in
another worksheet along with the cell names, and print that. Sorry, I do
not have such a macro.

--
Jim Rech
Excel MVP

| Instead of using column/row references in printing
| comments, I want the comments to use named ranges.
|
| Printed comments now look like this:
| Cell: A1
| Comment: The Senate Labor Relations hearing will include
| discussion of AB 3018.
|
| I want the printed comment (at the back of the worksheet)
| to look like this:
|
| Cell: April13
| Comment: The Senate Labor Relations hearing will include
| discussion of AB 3018.
|
| How do I do that?
|
|