do you mean a function used as a formula in a worksheet like

=MyCustomfuction(Sheet2!A1:Z26,3)

A function can't activate or select. but most of the time you don't need to.

so yes, I would say it can do what you ask, but you will need to clean up
your code.

--
Regards,
Tom Ogilvy


"Who I Am" wrote:

My sub code works fine. But if I turn it into function, it fails. Can I
use a function to get a result from another sheet?

What I am doing is to put the function in sheet1, then the function
will activate sheet2 where it filters a table and get a sum of a column

Thank you