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?

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
Cheers,

TV