Autofilter in Vba works fine for code in button_click but dosen't work as a function

Dear all ,

Please find Excel Sheet "testrange.xlsm"

I have a peculiar problem i have a code written to filter data in module1 which is asigned to button_click1 and works fine
but the same code as "module2" called as function dosen't show the same results.

Regards,
Raji

I believe a function is more or less just a Custom Formula, I don't think it can do actions like your macro can.I really haven't used UDF's much though

What comes up for you?

Using this:

Please Login or Register  to view this content.

I get the same output.


However, a worksheet function can only make changes to the cell that it resides in. It cannot affect the rest of the worksheet, hence it cannot filter data, etc.

Regards, TMS