Hi
I have 2 sheets (Main and help). I want to add the comment to cells in 'main' sheet from 'Help' sheet.
Dim V_comment As Range
Dim test As Range
Dim j
For j = 1 To 20
Set V_comment = ThisWorkbook.Sheets("Help").Cells(2 + j, 6)
Set test = ThisWorkbook.Sheets("Main").Cells(2, j)
With test
.ClearComments
.AddComment
.Comment.Text Text:=V_comment
End With
Next
I get erro in debug.
Would you please help me?
Thank you
Kati
Bookmarks