-
Solved: text to columns
I am importing a text file and have recorded a macro to convert text to columns
Everytime I run it it asks me if I want to "replace destinations cells"
How do I avoid this. I tried Application.EnableEvents = False
But the message keeps coming up. Is there a way I can avoid this as I always want to replace the destination cells
-
You could clear the sheet before importing the new data.
-
Hi, philfer,
I wouldn?t exclude the events behind the sheets (unless you forget to mention them) but use Application.DisplayAlerts = False for not displaying any Excel Dialogs at runtime (please turn them on explicitely at the end of the macro by setting the value to True again as the messages will not be displayed automaticly when the macro in ended).
Ciao,
Holger
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules