Function Call question

Hi there,

i'm supposed to write a fuction which takes two arguments array and size of array and retur true or false. i already implemented my function and everything but i have no idea how to test it. i mean How do i test my fuction in immediate window in Excel.

my fuction look like this: Function isUnique(myArray() as integer, mySize as integer) as Boolean

So how do i test it in immediate window.

Thanks

Use the Debug.Print method. Something like this...

Please Login or Register  to view this content.

debug.print doesn't work for me. I know how to call it in immediate window this is the example here"

Please Login or Register  to view this content.

BUt
i wanna call it like this

Please Login or Register  to view this content.

where 3 is mySize and numbers in {} are array elements but it is not working.

Type myArray as variant
Function isUnique(myArray As Variant, mySize As Integer) As Boolean

Then call it like this
?isUnique(array(1,2,4), 3)

is there any other way we can call this function in "immediate Window" like

Please Login or Register  to view this content.

and still don't have to change function prototye to Variant.

Please Login or Register  to view this content.