Am Tue, 25 Apr 2006 15:34:01 -0700 schrieb Bob Smith:
Bob, IŽm sure youŽd get an answer in an Excel related group, e.g. in:
microsoft.public.excel.programing
--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
--
www.vbOffice.net --
How do I check if a Cell has a comment field in VBA before I try and ADD a
comment?
e.g.
if Cells(A,1).Comment = "1"
Cells(A,1).Comment.Delete
Else
Cells(A,1).AddComment
Cells(A,1).Comment.Text("My Text")