Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to remove warnings about rewriting cells?
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 "Alexander Aliev" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for showing warnings when cells are out of range. | Excel Discussion (Misc queries) | |||
SAVING AND REWRITING CHARTS | Charts and Charting in Excel | |||
Need help rewriting a macro | Excel Worksheet Functions | |||
Rewriting equation for VB | Excel Programming | |||
Rewriting a formula... | Excel Discussion (Misc queries) |