View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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