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