LinkBack URL
About LinkBacks
I'm running the following code
The "other stuff" runs fine, but the autofill line fails (Autofill method of range class failed) until I manually select the sheet and continue the macro. Any ideas why?
Please Login or Register to view this content.
I'm running the following code
The "other stuff" runs fine, but the autofill line fails (Autofill method of range class failed) until I manually select the sheet and continue the macro. Any ideas why?Please Login or Register to view this content.
Last edited by bd528; 09-15-2010 at 05:40 PM.
Without qualification, the Range argument refers to the active sheet.
Entia non sunt multiplicanda sine necessitate
You must use the Range method with autofill.
Please Login or Register to view this content.
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
Thanks for the answers!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks