there.
I'm trying to retrieve comments from a pre-defined name range of cells, but I keep getting the error message for the instruction: Set c = Range("myRange").Comment.Value

Only the active workbook is open, range is there, etc.
In the meantime, a value has been assigned to c, that corresponds to very first cell of myRange.

Any ideas? thanks a lot.

[![error message](https://i.stack.imgur.com/x1dGc.png)](https://i.stack.imgur.com/x1dGc.png)

[![value returned to c](https://i.stack.imgur.com/7r35i.png)](https://i.stack.imgur.com/7r35i.png)

```
Sub Test_findComments_in_range()
Dim varComment As String
Dim c As Variant

With ActiveSheet
    For Each c In .Range("myRange")

    Set c = Range("myRange").Comment.Value

        If IsEmpty(c) Then

        MsgBox "No comment found! "

         GoTo jumpCycle3

        Else
            varComment = c.Value
            MsgBox varComment, vbInformation

        End If

jumpCycle3:    Next

End With

End Sub

```