philfer
12-31-2007, 12:49 PM
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
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