| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
TextToColumn when destination to other sheet
God day Group,
Is it at all possible to destinate the the split columns to another worksheet when using the TextToColumn wizard? Can it be made by code? When trying in the wizard I get the error message about wrong destination reference. Brgds CG Rosen |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
TextToColumn when destination to other sheet
Only the current sheet is possible
-- Gary''s Student - gsnu200908 "CG Rosen" wrote: God day Group, Is it at all possible to destinate the the split columns to another worksheet when using the TextToColumn wizard? Can it be made by code? When trying in the wizard I get the error message about wrong destination reference. Brgds CG Rosen |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
TextToColumn when destination to other sheet
I don't think so.
But you could copy the column range to a (separate, new, temporary) worksheet, do the text to columns and put the parsed data where you want. CG Rosen wrote: God day Group, Is it at all possible to destinate the the split columns to another worksheet when using the TextToColumn wizard? Can it be made by code? When trying in the wizard I get the error message about wrong destination reference. Brgds CG Rosen -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
TextToColumn when destination to other sheet
Thanks / cgr
"Gary''s Student" skrev i meddelandet ... Only the current sheet is possible -- Gary''s Student - gsnu200908 "CG Rosen" wrote: God day Group, Is it at all possible to destinate the the split columns to another worksheet when using the TextToColumn wizard? Can it be made by code? When trying in the wizard I get the error message about wrong destination reference. Brgds CG Rosen |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
TextToColumn when destination to other sheet
Thanks for info / cgr "Dave Peterson" skrev i meddelandet ... I don't think so. But you could copy the column range to a (separate, new, temporary) worksheet, do the text to columns and put the parsed data where you want. CG Rosen wrote: God day Group, Is it at all possible to destinate the the split columns to another worksheet when using the TextToColumn wizard? Can it be made by code? When trying in the wizard I get the error message about wrong destination reference. Brgds CG Rosen -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copied formulas refer to destination sheet not source sheet | Excel Worksheet Functions | |||
| sort source data sheet while destination shows same data | Excel Worksheet Functions | |||
| VBA .copy destination | Excel Discussion (Misc queries) | |||
| Destination range | Excel Discussion (Misc queries) | |||
| Hyperlinks - identifying source in destination sheet | Excel Discussion (Misc queries) | |||
Linear Mode
