removing excel filters using VB macro
-
first of all i am not sure, that this is the right place. Since I did not find any place to place my question regarding an excel macro, I am using this place because the macro is being written using VB. Consider a case, where I am opening an existing excel file that has filters. If I want to disable/remove/delete the filters, how can I can i do it in the same macro. Thanks.
Keshav Kamat :) India
-
first of all i am not sure, that this is the right place. Since I did not find any place to place my question regarding an excel macro, I am using this place because the macro is being written using VB. Consider a case, where I am opening an existing excel file that has filters. If I want to disable/remove/delete the filters, how can I can i do it in the same macro. Thanks.
Keshav Kamat :) India
never mind guys. i found it. for ur reference http://support.microsoft.com/default.aspx?scid=kb;en-us;141770[^]
Keshav Kamat :) India