text to columns
 

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

text to columns
 

Use Application.DisplayAlerts = False

--
David Hager
Excel MVP

"TimO" wrote in message
...
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