TextToColumn when destination to other sheet

  • Thread starter Thread starter CG Rosen
  • Start date Start date
C

CG Rosen

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
 
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.
 
Thanks for info / cgr

Dave Peterson said:
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.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help: Text to Columns & MDY 2
match function - date and time 1
Macor 3
TextToColumns prompt 4
sub TextToColumns 1
Multi listbox change event - selected or deselected 6
Image on userform from picture in a worksheet 2
Macro changes formulas on destination worksheet 2

Back
Top