View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Alexander Aliev Alexander Aliev is offline
external usenet poster
 
Posts: 2
Default How to remove warnings about rewriting cells?

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