Function 19)

19) Add Function UsedRange

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

Using the function

=UsedRange(Range)

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