Function 19)

19) Add Function UsedRange

Returns the Intersection of the “used range” and your “criteria range”.

Using the function


You can wrap your range inside this function to force potentially quicker calculations.

I use primarily with other User-Defined functions to narrow the overall range so that my UDF will calculate more quickly.

Queries | Lists | Find | Alter | Clean | Sum | Functions | Help | Misc