How to use a public function in a similar way as worksheetfunction in VBA?

Hi,

I’m writing a very large VBA macro to analyze data from multiple worksheets. All my functions are used in the following form (example):

Please Login or Register  to view this content.

Now, at the end of a laborious process, I need to use a function in the macro, that is not a standard Excel worksheet function (counting conditional unique values). I managed to find a public function that does the trick perfectly (here called UniqueCountv4). If I try to use this like in the example things go wrong. Is there anyone who knows how to fix this problem? I would be REALLY grateful I anyone could provide me with a solution.

Please Login or Register  to view this content.

Who can help me?

Steven Laporte

Moderators Note:
Hello Steven & Welcome to the Board,
Please follow Forum Rule #3 about the use of code tags. Added for you this time, but please use them in the future…Thanks.