Maximum Comment Line

[mohanvijay]

Hai All,

I add comment to cell by VBA by using below code

.Cells(i, J_Col).AddComment T_Comm_str
Set O_Comm = .Cells(i, J_Col).Comment
With O_Comm.Shape
    .Width = COMM_Width
    .Height = COMM_Height
end with
 
'some code to format the comment

it goes well but when the comment shows upto only 254 lines ( i use VbLf for new line) but comment data contains all lines in attaced workbook
the comment only shows upto 254 lines but when i copy the text of comment and paste into another excel (as data) it pastes all data (538 lines)

why the comment shows only upto 254 lines is that limit

please help

[mikerickson]

254 lines in a comment?

Excel is a spreadsheet, not a word processor.

A comment is a marginal note.
Conseptualy, it is smaller than the cell that it comments.
254 lines requires a scroll bar.

A comment is a small note. I'm surprised that you got it to show 254 lines.

[mohanvijay]

Thanks for Reply mikerickson

didi you see attached file?

in that file the comment contains data upto 538 lines but shows only 254 lines if 254 line is limit then why the comment holds data upto 538 lines

any help?