Undo all filters before running a macro [Closed]

Report
-
Posts
85
Registration date
Friday June 10, 2011
Status
Member
Last seen
April 28, 2012
-
Hello,

dear all, I have an invoice template in a worksheet in excel 2007.. By clicking two buttons ,I will 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.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 want your help in "automatically undo 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 all names in that column before running the macros. hope I have conveyed my problem correctly...bye suryam

1 reply

Posts
85
Registration date
Friday June 10, 2011
Status
Member
Last seen
April 28, 2012
2
Greetings,

Remember ...

Before any answer given on the forum, you should know that there are volunteers who give their time trying to solve user problems.

Therefore, it is specifically requested from Kioskea forum users to show their respect. For this, the use of polite expressions is a minimum.
https://ccm.net/contents/948-terms-of-use-for-ccm-respect-for-others#politesse

Say please, thank you, appreciate, grateful, regards, etc... is common practice when you want something especially help!

So re-write your message respecting the politeness charter by using these words and repost your message on the forum.

We trust that you understand.

And you report the thread as no respect to the politeness charter.

Thank you

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!