255 truncation
On Fri, 18 May 2012 13:03:36 -0400, GS wrote:
By default, Excel's limit for copy/paste operations is 255 characters.
To work around this I usually enter EditMode (F2) to paste data copied
from web pages (or any other content containing html/php). Sometimes,
I'll paste in Notepad first, then edit as required, then copy/paste to
a cell AFTER entering EditMode.
Any sheets being copied also lose any characters beyond the 255 limit.
BUT - I have definitely posted similar web pages in the past - both manually
and also in VBA - I wonder if I was entering edit/mode without knowing.
Anyway - cheers I will give it a go.
|