Why does Range.Precedents called from an Excel VBA UDF work differently than when called from the immediate window, and is there a workaround?
When called from an Excel VBA UDF, Range.Precedents returns the range and not its precedents. Is there a workaround?