Hi,

thanks for your reply.

but if i am copy pasting from somewhere else into excel worksheet, then
at a time of getting length of that cell it should consider carraiage
returns as well as line feed characters.

And I tried with just typing character 'a' 32767 number of times in
notepad without pressing any newline character.

In this case also workbook not accepting those many charcters. I
checked whether there is any newline charcater or not. But this text
doesn't contains new line character.

Ya you are right that if i try rept("a",32767) then it is filling cell
properly but when i try to copy from notepad or word pad to excel cell,
it is not working.

Do you have any idea about this.

Any help will be appreciated.

Thanks in advance.