| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
is it fair?
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... |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
is it fair?
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. driller wrote: 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
is it fair?
Thanks Dave P. for the manual instruction...
"what a twist...Any suggested set-up or VBE? pls. help..." "Dave Peterson" wrote: 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. driller wrote: 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
is it fair?
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. driller wrote: Thanks Dave P. for the manual instruction... "what a twist...Any suggested set-up or VBE? pls. help..." "Dave Peterson" wrote: 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. driller wrote: 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 -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
is it fair?
Do you have one macro like that ? pls. share it..
"Dave Peterson" wrote: 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. driller wrote: Thanks Dave P. for the manual instruction... "what a twist...Any suggested set-up or VBE? pls. help..." "Dave Peterson" wrote: 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. driller wrote: 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 -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
is it fair?
No, but you can have one in a matter of seconds. Just turn on the macro
recorder and do it. driller wrote: Do you have one macro like that ? pls. share it.. "Dave Peterson" wrote: 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. driller wrote: Thanks Dave P. for the manual instruction... "what a twist...Any suggested set-up or VBE? pls. help..." "Dave Peterson" wrote: 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. driller wrote: 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 -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| create links to check boxes marked "good" fair"and "bad" | Excel Worksheet Functions | |||
| Science Fair Project | Excel Worksheet Functions | |||
| Fair Play | Excel Worksheet Functions | |||
| Fair Market value Spread sheet for donations. | Excel Discussion (Misc queries) | |||
Hybrid Mode
