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