Skip to content
REFERENCE

U.OFFSET

Summary

Returns the values of a range that is offset a specified number of rows and columns from a starting range. Non-volatile version of Excel's native OFFSET method.

Syntax

=U.OFFSET(start_range, row_offset, column_offset, [height], [width], [as_range_ref], [allow_ref_errors])

Parameters

Parameter Required Description
start_range Yes A reference to a range of cells from which offsets will be applied. Hard-code "self" to make calling cell the start range
row_offset Yes The number of rows to shift from start_range. Set to zero if not a valid number
column_offset Yes The number of columns to shift from start_range. Set to zero if not a valid number
[height] No The height of the range to be returned. If not set the range returned has the same height as the start_range
[width] No The width of the range to be returned. If not set the range returned has the same width as the start_range
[as_range_ref] No If set to TRUE then a reference to the offset range is returned. If set to "id" then a range_ref ID for the offset range is returned. By default the values of the offset range are returned
[allow_ref_errors] No If set to TRUE then a #REF error will be returned if the specified offsets would move the range outside of Excel's sheet boundaries. By default the returned range shrinks when it hits a sheet boundary

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

=U.OFFSET(B5,K5,K6)

=U.OFFSET($B$5:$C$6,K15,K16)

=U.OFFSET($B$5:$C$6,K23,K24,K25,K26)

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.