Releasing filter before running a macro

Solved/Closed
suryam - Aug 3, 2011 at 01:49 AM
 suryam - Aug 3, 2011 at 12:38 PM
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 responses

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Aug 3, 2011 at 05:46 AM
sheets("sheet1").autofiltermode=false
0
Mr. Rizvisa1, thanks very much for your help. Big "salute" to your knowledge. thanks again. my issue is solved. thanks bye suryam
0