Releasing filter before running a macro [Solved/Closed]

Report
-
 suryam -
Hello,
dear all friends, good morning.
I have an invoice template in a worksheet in excel 2007.. By clicking two buttons ,I will be able to store some cell contents of the invoice template in a work sheet "invoices-list" and some other cell contents in another work sheet "credit-list".
I got macros to get this done through our forum friends and contributors.

great thanks to all of them.

Now my problem is :
suppose I have filter on a particular item in some column either in invoices-list or in credit-list. or both.....by not noticing that if I run the macros in my invoices template...then the newly copied rows are replacing the existing data in the filter range (over writing)...this should not happen...

so I request you to help me in "automatically undo/release all filters, if any" in all sheets before running the macros. I mean ..suppose there is filter by item say "ram"...then it should be released before running the macros. hope I have conveyed my problem correctly...

your help will be greatly appreciated... thanks in advance

suryam


2 replies

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
sheets("sheet1").autofiltermode=false
Mr. Rizvisa1, thanks very much for your help. Big "salute" to your knowledge. thanks again. my issue is solved. thanks bye suryam

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!