mohanvijay
08-23-2011, 05:10 AM
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
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