HasComment ?!?
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
|