I have a template that I have been using for years. It seems after at work we were upgraded to Windows 10 I get several intermittent errors when I run certain macros on my template.
I get "Run-time error '1004': ClearContents method of Range class failed" when I use the macro to delete the contents in the template. It always worked before now it periodically won't.
This is the macro: When I click debug the 5th line in the macro where it says "Selection.ClearContents" is shaded yellow.
I also get Run-time error '-2147417848 (80010108) Automation error The object has disconnected from its clients. This happens when I am running a macro that does text to columns. Like the previous one it always worked before and now periodically I get this error message.
Here is the macro:
The only work around is that I have to close the template, close Excel and open it again. This is rather annoying. I am not a techie or anything but I would like to know why this is happening and how to correct it. All of my other templates work fine.
I have looked up why this could be happening and I can't find anything that matches my situation on any forums that could help me.
Thanks
Bookmarks