What is the secret incantation to use for this?
<range>.HasComment doesn't exist
Comment = Nothing is "invalid use of object"
Several other guesses got the same
Not checking gets "Ob Var or With not set"
--
Wes Groleau
Code:
With Cells(x,y)
If .HasComment then
DoSomething(.Comment.Text)
End If
End With
<range>.HasComment doesn't exist
Comment = Nothing is "invalid use of object"
Several other guesses got the same
Not checking gets "Ob Var or With not set"
--
Wes Groleau