Make sure that both workbooks are open in the same session of excel.

If this doesn't help, then give some more info about how you're doing the
copy|paste.

emmateagle wrote:

Hi

I'm trying to copy between 2 excel spreadsheets, when i do, the end column,
which contains more than 255 characters, has the end chopped off. How can i
increase the amount of characters that I can copy?

Any help would be appreciated.

Thanks!

--

Dave Peterson