excel code

[osorico]

Quote from dtrader98:
I guess what you meant by typing in the same as passed in array, was that the data type declarations had to be identical (both arrays must be declared long or variant)? My data array data(100) was declared as variant.

Exactly correct.

I then changed all the Function's long declarations to variants and it accepted them.

Other than variants offer bad performance compared to longs or other numerics especially for loops, no harm. Won't notice it counting to 100, but not needed.

The only other thing is it complained about Debug.Assert False
as a syntax error, so i just commented it out as it worked ok without it.

Using an OLD version of XL eh?
Debug.Assert false is for debugging only. Similar to putting a break on a line or a code-friendly Stop statement.

But this is great, thanks very much for helping on this.

Osorico