is it fair?

[Guest]

I'm fond of placing long text in a cell, also would like to learn long
formulas derived from refencing functions like offset, match and row...
Most of the time, I record a long master formula as text to assure that i
have it safely...
Yet due to my scrambled files, wherein I have to copy/move sheets into
another workbook...I see pop-up message like....

"The sheet you are copying has cells that contain more than 255 characters.
When.....only the first 255 characters in each cells are copied"

But after some cross check, the active formula which contains the same
number of characters are completely copied. argghhhh. what a twist...Any
suggested set-up or VBE? pls. help...

 

[Dave Peterson]

Copy the sheet the way you want.

But then come back and select all the cells on the original sheet
edit|copy

and then paste all the cells into the new worksheet.

And check your long descriptions--maybe they got truncated.

 

[Guest]

Thanks Dave P. for the manual instruction...

"what a twist...Any suggested set-up or VBE? pls. help..."

 

[Dave Peterson]

I don't know what "set-up or VBE" means?

If you mean you want a macro to do this, you can record one when you do it
manually.

 

[Guest]

Do you have one macro like that ? pls. share it..

 

[Dave Peterson]

No, but you can have one in a matter of seconds. Just turn on the macro
recorder and do it.

Do you have one macro like that ? pls. share it..