Function 22)
Add Function USEDRANGE to active workbook
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