Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting comments
Hi Mark,
Selection.ClearComments Range("A7:G28").ClearComments Cell Comments http://www.mvps.org/dmcritchie/excel/ccomment.htm --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Mark" wrote in message ... I am using Excel 97. Can someone please help me with some code. I want some code which looks at a worksheet and deletes any comments within a range of say A7:G28 Thanks in advance -- Mark A Whitehead |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel 2000 how to format the comments font all comments | Excel Discussion (Misc queries) | |||
deleting comments | Excel Discussion (Misc queries) | |||
anchor comments to cell while inserting and deleting rows | Excel Discussion (Misc queries) | |||
Add comments without deleting. | Excel Discussion (Misc queries) | |||
Deleting comments | Excel Programming |