I would surmise the problem is somehow concerned with the fact that it
returns a single range object. This would work if all the precedents were
on a single sheet - either the same sheet as the formula or on the same
external sheet. However, if the arguments involved a mix of sheets, then a
single range object can not address multiple sheets. Perhaps the function
should return an array.

--
Regards,
Tom Ogilvy

"deko" wrote in message
m...
However, It doesn't work for linked to cells - cells on other
worksheets,
on
cells/ranges on the same sheet.

Yes, I discovered this limitation - which conflicts with the requirements
I
was given. I don't see why the Excel team couldn't make this work.