Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting comments
"Mark" wrote in message
... I want some code which looks at a worksheet and deletes any comments within a range of say A7:G28 Hi Mark, This should do it: Range("A7:G28").ClearComments -- Rob Bovey, MCSE, MCSD, Excel MVP Application Professionals http://www.appspro.com/ * Please post all replies to this newsgroup * * I delete all unsolicited e-mail responses * |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting comments
Hi,
you can use following code Sub delete_comments() Dim cell As Range On Error Resume Next For Each cell In Range("A7:G28") cell.Comment.Delete Next cell On Error GoTo 0 End Sub Regards, Jare -- Message posted from http://www.ExcelForum.com |
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) | |||
in excel useing comments how do you add clip art to comments? | New Users to Excel | |||
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) |