ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   how to print defined cell names with comments, not numbers? (https://www.excelbanter.com/new-users-excel/49247-how-print-defined-cell-names-comments-not-numbers.html)

mayfield1814

how to print defined cell names with comments, not numbers?
 
My overall task is to print comments at the end of the sheet that display the
defined cell name instead of the cell number.

Problems: How do I define all of the intermediary cells based on the row and
column headings, and then how do I print the comments to display the defined
name, instead of the number.

For example, I would like my print out to display:

Cell: "Defined Name"
Comment:

Instead of:

Cell: B2
Comment:




All times are GMT +1. The time now is 09:40 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com