Skip to content

excelSetRangeOffsetContextWithinWorksheet (Excel Verification, Manipulation & Persistence)

Compatible with:
  • Purpose
  • This command is used to create new range offset in memory with a name as specified in 'Value' field
  • The given offset should within the specified range
  • Syntax
  • excelSetRangeOffsetContextWithinWorksheet(variableHoldingWorksheetHandle||rangeOffset, variableHoldingRangeOffset)
  • Target
  • variableHoldingWorksheetRangeHandle||rangeOffset
  • Value
  • variableHoldingRangeOffset
  • Return Value
  • N/A
  • Errors & Exceptions  
  • Condition Error/Exception Message
    Invalid Range Offset The RangeOffset provided as input is invalid for the current worksheet range.
    Invalid Syntax Invalid syntax is used for defining the range.