The problem I am having is that I have written a code to copy comments to a comment sheet. It works well,however, somwtimes I get #Value instead of the comment. I thought that the comments box may be limited, but the comments stay in the comment box. I don't know where the problem is.
Any help you can give is very appreciated. I have posted my codes below.
Copy comments to sheet2:
On Error GoTo errhandler
For Each oCell In Range("al1:al1000").SpecialCells(xlCellTypeComments)
Select Case oCell.Comment.Text
Case Is <> ""
holder = oCell.Comment.Text
oCell.AddComment holder & vbCrLf & vbCrLf & vbCrLf & vbCrLf _
& Space(75) & Environ("Username") & vbCrLf & Space(75) & Date
Sheets("sheet2").Range("a65536").End(xlUp).Offset(1, 0) = oCell.Offset(0, -34)