Automation (error 1004)
 

I need a surefire way to setup a macro to be re-run (a thousand times even).
I have tried to delcare ap, workbook, and worksheet as variables and then
insert xlsheet before all necessary lines; however, it never works right.

Then I get other errors and I end up rewriting about a 1/3 of my code.

What are some really good ways for setting up a macro for automation that
you have discovered?