UDF returns different result in worksheet to that in VBA
Thanks to both of you for the answers. A picture is worth a 1000 words.
To Peter,
I appreciate your taking the time to answer and the first part of your
answer confirms
to me that it is is just an idiosyncrasy of Excel.
I completely misunderstood what you were referring to by "Look at the Hidden
property of rows in the filter range". I thought that you meant that it would
explain all about the first part of your answer and I couldn't make the
connection.
I am now assuming that Gary's Student correctly interpretted what you meant
and it now makes sense.
By the way at this point in time I don't need it as a worksheet function and
can't even think of a use for it as a worksheet function at the moment. I
only want the VBA to copy filtered results and decided to come up with
something generic. I just had the function in a cell during testing.
--
Regards,
OssieMac
|