Is there a way to copy more than 255 characters in a cell when copying into a new workbook?
J JR Jun 20, 2007 #1 Is there a way to copy more than 255 characters in a cell when copying into a new workbook?
D Dave Peterson Jun 20, 2007 #2 Make sure both workbooks are opened in the same instance of excel. Open the first workbook anyway you want. File|open the second workbook Then do the copy|paste.
Make sure both workbooks are opened in the same instance of excel. Open the first workbook anyway you want. File|open the second workbook Then do the copy|paste.
J Jim Rech Jun 20, 2007 #3 The error message you get when you copy an entire sheet with this issue to another workbook suggests that you copy the cells instead of or in addition to copying the sheet. Doesn't this work? This problem was fixed in Excel 2007, btw.
The error message you get when you copy an entire sheet with this issue to another workbook suggests that you copy the cells instead of or in addition to copying the sheet. Doesn't this work? This problem was fixed in Excel 2007, btw.
