Releasing filter before running a macro

 suryam -
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 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


2 replies

Registration date
Thursday January 28, 2010
Last seen
August 2, 2020
Mr. Rizvisa1, thanks very much for your help. Big "salute" to your knowledge. thanks again. my issue is solved. thanks bye suryam