Make UDF function flexible to any sheet

[YasserKhalil]

Hello everybody
I have devised this udf function that brings the address of the last non zero of specific range

Please Login or Register  to view this content.

Please Login or Register  to view this content.

It is working well but for the activesheet only
How it can be fixed to deal with any sheet specified in the parameters ..or I imagine

Please Login or Register  to view this content.

If Sheet1! existed so the function would deal with Sheet1 and if missing to deal with the active sheet
I tried to fix it but I failed

Thanks advanced for any help

[berlan]

try (untested)

Please Login or Register  to view this content.

If you only write Cells( ...) it will give you the references on the activesheet. rng.parent = the sheet from the range, so I added that. See how it works, no other changes..

[YasserKhalil]

Mr. Berlan
I struggled for two hours trying to fix it and you fixed it in a minute with just one magic word "parent"
Thank you very much for this great really great help
Regards

[berlan]

You're welcome buddy, and thanks for the kind feedback and rep