How to remove warnings about rewriting cells?

[Alexander Aliev]

Hallo,

I need to remove these questions which appear during
"Selection.TextToColumns" and "Selection.Cut Destination:=<where>" .
Because I know the answer and it always "yes".

I supposed that "Application.EnableEvents = False" before all actions
should resolve the problem but this applied only to "Selection.Cut".

Is there a way to overcome this?
Thank you for any hint.
Alexander

 

[Joel]

Record a macro while you perform the operations manually. then use the
recorded macro in your own code. The problem is you are not including all
the parameters need fro the two instructons. Once you add all the options
into the code the questions will disappear. You didn't really supply enough
information to provide all the options the way you need them.

1) Tools - Macro - Record New Macro
2) perform the Text-to-columns and the Copy and Paste.
3) Tools - Macro - Stop Recording