Can you reference a worksheet outside of the workbook you're i
So copy the sheet.
After you get that warning message
go back to the original sheet
select all the cells
edit|copy
Then off to the newly copied sheet
Edit|paste
MeWivFree wrote:
I get this message when I try to make a copy of the worksheet:
"The sheet you are copying has cells that contain more than 255 characters.
When you copy the entire sheet, only the first 255 characters in each cell
are copied.
To copy all of the characters, copy the cells to a new sheet instead of
copying the entire sheet."
Ali
"Gord Dibben" wrote:
Should read "does not"
Gord
On Mon, 05 Feb 2007 15:03:47 -0800, Gord Dibben <gorddibbATshawDOTca wrote:
Copying a worksheet does restrict you to 255 characters in a cell.
--
Dave Peterson
|