Hi Tushar

Thank you also for your explanation.
If MS ever delivers on its
stated claim of trustworthy computing all these 'tricks' will break.
Well, we live on a farm and all the pigs here are still on the ground <VBG
--
Regards
Roger Govier
"Tushar Mehta" wrote in message
om...
In article ,
says...
Harlan
That is awesome and works as described.
I have been trying to work out how it works, but can't quite figure it
out.
Could you explain?


It relies on the fact that XL doesn't validate the arguments to a bunch
of functions, all of the lookup type. If MS ever delivers on its
stated claim of trustworthy computing all these 'tricks' will break.

In this case the garbage spewed by MS's reliance on GIGO happens to be
someone else's treasure. {grin}

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions