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 *

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