So this is the relevant portion of code.
The error comes up with the last line where I add the comment.
Range("B1").Select
mystring = ActiveCell.Value
ActiveCell.Offset(0, 1).Select
Do
If IsEmpty(ActiveCell) = False Then
mystring = mystring & ", " & ActiveCell.Value
Else
End If
ActiveCell.Offset(0, 1).Select
Loop Until IsEmpty(ActiveCell)
Worksheets("Results").Activate
TickersResults.AddComment (mystring)
End Sub
I just tested the string with this line
Range("A30").Value = "" & mystring & ""
and the cell turns the appropriate value, so the string functions perfectly.
Not sure what the error is with adding the comment.
Any ideas?
Thanks a lot in advance
Bookmarks