:: infotechGuyz.com ::
> For the IT community by the IT community

Excel 2010 Macro Add Comments

 

Beginning with Excel 2007, you can add comments about names. You can add additional information, such as why the name was created or where it is used.

To insert a comment for the local name LocalOffice, do this:

ActiveWorkbook.Worksheets(“Sheet7”).Names(“LocalOffice”).Comment = _

“Holds the name of the current office”

 

The comments will appear in a column in the Name Manager.