I want to build a routine which checks all the cells in a workbook t
see if any comments exist. I then want to print the cell addresses o
each of these cells in a summary sheet AND as hyperlinks. For example:

Sheet1!A1
Sheet21B4
Shee3!H678

So when I click onto Sheet1!A1 in this list, it will take me to tha
cell.

Does anyone know how to do this?

Thn

--
ExcelMonke
-----------------------------------------------------------------------
ExcelMonkey's Profile: http://www.excelforum.com/member.php...nfo&userid=522
View this thread: http://www.excelforum.com/showthread.php?threadid=27520