Skip to content
REFERENCE

U.RANGE_REF

Summary

Returns one or more unique identifiers that U methods can convert into an Excel range reference. This method enables having a multi-range parameter refer to different sheets in the workbook, which is otherwise not supported by Excel

Syntax

=U.RANGE_REF(range, [range__or__address_or_name], [range__or__as_excel_ref], [range], [range], [range], [range], [range], [range], [range], [range], [range], [range], [range], [range], [range], [range], [range], [range], [range])

Parameters

Parameter Required Description
range Yes The range for which a unique identifier will be returned. Returned ID is only valid for current process. If hard-coded to "self" then ID of calling cell is returned
[range] OR [address_or_name] No The next range for which a unique identifier will be returned. If set to TRUE then the first parameter is interpreted as containing either an Excel address string or a named range, and the returned reference will refer to that range; Use "selection" or "prior_selection" to return ID of current/prior selected range
[range] OR [as_Excel_ref] No The next range for which a unique identifier will be returned. If set to TRUE then the result is returned as an Excel reference instead of as an U range identifier suitable for use in native Excel methods
[range] No The next range for which a unique identifier will be returned. Returned ID is only valid for current process
[range] No The next range for which a unique identifier will be returned. Returned ID is only valid for current process
[range] No The next range for which a unique identifier will be returned. Returned ID is only valid for current process
[range] No The next range for which a unique identifier will be returned. Returned ID is only valid for current process
[range] No The next range for which a unique identifier will be returned. Returned ID is only valid for current process
[range] No The next range for which a unique identifier will be returned. Returned ID is only valid for current process
[range] No The next range for which a unique identifier will be returned. Returned ID is only valid for current process
[range] No The next range for which a unique identifier will be returned. Returned ID is only valid for current process
[range] No The next range for which a unique identifier will be returned. Returned ID is only valid for current process
[range] No The next range for which a unique identifier will be returned. Returned ID is only valid for current process
[range] No The next range for which a unique identifier will be returned. Returned ID is only valid for current process
[range] No The next range for which a unique identifier will be returned. Returned ID is only valid for current process
[range] No The next range for which a unique identifier will be returned. Returned ID is only valid for current process
[range] No The next range for which a unique identifier will be returned. Returned ID is only valid for current process
[range] No The next range for which a unique identifier will be returned. Returned ID is only valid for current process
[range] No The next range for which a unique identifier will be returned. Returned ID is only valid for current process
[range] No The next range for which a unique identifier will be returned. Returned ID is only valid for current process

Behavior

The documented public interface is supported by the current U Add-in source signature and the maintained Usage Examples workbook. Optional parameters are shown in square brackets in the syntax above; omit the brackets when entering a formula.

Return Value

Returns the function result or action status described by the formula and parameters above. The maintained sources do not define a narrower, stable return contract for this function.

Examples

=IF(Z4="","",U.RANGE_REF(Z4,TRUE))

=IF(AC4="","",U.RANGE_REF(AC4,TRUE))

=U.SET_CLICKVALS("back_nav",AH5:AH189,U.RANGE_REF($A$1),,,,"ALL")

Notes

  • Formula examples are preserved from maintained workbook usage and normalized to the current U. prefix.
  • Complete formulas demonstrate working patterns; they do not imply that undocumented option values are supported.
  • Where maintained sources do not specify every accepted value, default, or error message, this page does not infer one.
  • For functions that perform actions, use a visible trigger or supported block/throttle parameter to avoid unintended repetition during recalculation.