Hi there, long time reader first time poster...
Excel 2007, Data- Analysis add-ins installed.
I'm recording a macro to do gobs of copy/paste and column fills for me (filling a data analysis spreadsheet for different datasets in the same format), and interspersed in these copy/paste/autofill actions I occasionally recorded myself using the Sample add-in to make a list of every 6th entry in a column.
When I run the macro, all begins as it should, until it gets to the first time I ran the add-in. When it gets there, I get the following error message:
"Run time error '1004'. Method 'run' of object '_Application' failed"
I have a suspicion that this has something to do with which window or button is active (based on my searching around) but I'm hoping someone can take a look at my code and give me something to go on.
Here 'tis (note, its the first few lines of a LONG macro):
Its thePlease Login or Register to view this content.
that causes the error.Please Login or Register to view this content.
I've subscribed to the thread, so I'm ready to try any suggestions.
Bookmarks