View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
OssieMac OssieMac is offline
external usenet poster
 
Posts: 2,510
Default 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