I am facing problem in writing macro / vb code in excel.

It is not allowing me to copy more than 256 chars of a cell.

Is there any solution to this problem??

I tried copying 500 charactter in Excel 2003 and was successful. Add a
=length(B5) and verify that the count is wrong. It may jst be a display
problem. I believe I read on this website that Micrtosoft says you can copy
more than 256 charracter, they just won't display over 256.

"Sunrays17" wrote:

I am facing problem in writing macro / vb code in excel.

It is not allowing me to copy more than 256 chars of a cell.

Is there any solution to this problem??

they won't display more than approximately 1024 without extra effort.
Approximately because it won't just quit in the middle of a cell.

--
Regards,
Tom Ogilvy

"Joel" wrote in message
...
I tried copying 500 charactter in Excel 2003 and was successful. Add a
=length(B5) and verify that the count is wrong. It may jst be a display
problem. I believe I read on this website that Micrtosoft says you can
copy
more than 256 charracter, they just won't display over 256.

"Sunrays17" wrote:

I am facing problem in writing macro / vb code in excel.

It is not allowing me to copy more than 256 chars of a cell.

Is there any solution to this problem??