Locating Comments in a Worksheet
Need to write a macro to locate comments recorded in a worksheet without
having to create a seperate list. |
Locating Comments in a Worksheet
On 20 Mar, 00:18, Ray Clark
wrote: Need to write a macro to locate comments recorded in a worksheet without having to create a seperate list. Depends what you need this for. Without any VBA at all, you can get the comments to print out: From File, Page Setup, Sheets, Comments: At End of Sheet If you need to locate (select) cells with comments, use Goto....Special....Comments. or the following VBA: Sub SelectComments() Selection.SpecialCells(xlCellTypeComments).Select End Sub For more options, I'd suggest David McRitchie's website, which includes code for writing all comments out to a txt file: http://www.mvps.org/dmcritchie/excel/ccomment.htm HTH Andrew |
All times are GMT +1. The time now is 04:56 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com