Dear Forum,
I am applying Auto filters in 4 Sheets using VBA, it shows the Auto Filter in all the 4 sheets however, it does not work...
So what could be the reason and how do I make it work..
I am using Excel 2003 at work where I need this to work...
After removing the existing Auto filters by doing ALT + D + F.
And putting them manually it starts working so whats the reason behind this ?
Thanks in advance
Warm Regards
e4excel
Can you upload your workbook with code?
________________________________________________________
If your problem is solved, update the thread as SOLVED: Go to the top of the first post-Select Thread Tools-Select Mark thread as Solved OR - Go to the first post - Click edit- Click Advance- Just below the word "Title:" you will see a dropdown with the word No prefix.- Change to Solve- Click Save.
Show your gratitude to the person who helped you solving your problem by clicking on star button at the bottom of such post.
Unfortuantely, it contains Confidential data so I am uploading the code to give you an idea..
Please Login or Register to view this content.
I am trying to copy the different records from the Consolidated sheet to the 4 different sheets based on the filters..
Warm regards
e4excel
I tried this code in my system and it is working. Unless I have a file that you have problem with, it is difficult replicate the same problem.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks