Hello all,
I am working on a project in Excel 2010/2007 however the final product will be utilized on a computer that has Excel 2003. I say all this because I think this is the culprit for this error message:
[/B]Run time error '1004' Autofilter method of Range class failed[/B]
and when I debug, it points me to this part of the code:
Can someone tell me how I can fix this problem? Thnx.
Please Login or Register to view this content.
-HP RodNuclear
Last edited by HP RodNuclear; 12-15-2010 at 11:58 AM.
I just ran this code with 2003 and there was no error.
If you're happy with someone's help, click that little star at the bottom left of their post to give them Reps.
---Keep on Coding in the Free World---
Hi,
Is the sheet containing the A3:W3 range you are trying to filter the Active sheet when you run this macro? If not try explicitly including the sheet name. i.e. (and note that you don't need the .Select statement.
Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
I tried changing the code to match what you suggested but I still get the same error message. This is what I put:
Please Login or Register to view this content.
Hi,
Would you upload your workbook - or at least a suitably anonymised version of it.
Rgds
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks