Hello,
I have searched for this and come up with nothing
I have tried the simple code below to see if it will identify if a cell's comment is blank or not. Is the use of 'Not IsEmpty(...)' the correct approach?
Cheers,![]()
Sub test() Debug.Print Not IsEmpty(Cells(1, 1).Comment) If Not IsEmpty(Cells(1, 1).Comment) Then MsgBox ("this cell does not have a comment") ElseIf IsEmpty(Cells(1, 1).Comment) Then MsgBox ("this cell has a comment") End If End Sub
TV
Bookmarks