Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
For the user's stated problem, how about just
Sub RemoveA1Comment On Error Resume Next Range("A1").Comment.Delete End Sub On Fri, 22 Aug 2003 18:37:33 +1000, "John" <john.iseppi.iinet.net.au wrote: Sub Macro1() Dim c As Comment For Each c In ActiveSheet.Comments If c.Parent.Address = Range("A1").Address Then c.Delete End If Next End Sub "Tom" wrote in message ... Hi I'd like to check, if the cell A1 contains a comment. If yes, the comment should be deleted. But the problem is, that the HasComment-property is not available. How to do? Tom |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|