Better way to find minimum value excluding zero and non number

Hello,
Here's a suggestion using a custom function that you can adapt.
You pass a range to the function to get the minimum.
In the example, you select a range of cells and execute the macro "test"...

Please Login or Register  to view this content.

If you have a large range with multiple cells, you can use an array to make it faster :

Please Login or Register  to view this content.

Hi,

I do not think it works that way, in both cases function will return last non-zero numeric value, because all the time it is compared with max

taking second function as example working way would be:

Please Login or Register  to view this content.

By te way: max could be bigger (double can be some 1.79 × 10^308).

@Kaper,
Thanks for the correction...
I answered to rapidly without testing the code...

well, two main ideas behind structural programming (using subs and functions) are code reusing and keeping code readable (not to mention reccursion and other benefits).

anyway, you white the code

Please Login or Register  to view this content.

below your End Sub or in separate module
and in main sub you call it just the same way you call built-in functions, so for instance:

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

Of course you can built-in the function in your main code, but as it is already written as a function there is no real need to do it (non-structural code could execute a tiny bit faster because there could be some overhead for calling function).

Please Login or Register  to view this content.