text to columns

  • Thread starter Thread starter TimO
  • Start date Start date
T

TimO

I have a procedure that turns multi-character data in a
single cell (Thanks to Tom Ogilvy) to "text-to-columns"
after the user inputs data into the particular cell.

Before the operation is complete, I get a message box
asking "Do you want to replace the contents of the
destination cells?"

Is there a way to hide or defeat this message box so the
process is seamless to the end user? I have tried runing
the code while recording to see if the procedure of me
selecting "OK" would be recorded, but it is not.
BTW:There is nothing currently in the destination cells
Thanks in Advance
 
Back
Top