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

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

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

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

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