Set Named Range

This action marks the found range as a named range, so that it can be used as a reference when finding ranges in subsequent steps.

This is useful if several steps should work relative to this range.

Properties

The Set Named Range action can be configured using the following properties:

Range Name

Has two options, Auto or Named.Auto gives the range a name which is number. The first Auto-numbered range will have number 1, the next number 2 etc. Note that the number may change if additional Auto-numbered ranges are inserted before this step (on the same page).Named gives the range a fixed and explicitly stated name, which has several advantages:

  • It is easier to remember what the named range identifies if it has a well-chosen name
  • An explicitly named range is not affected if another named range is inserted before it
  • If you use the same name again in Set Named Range, the name will simply be made to refer to the new range (useful for stateful in-page looping)
Keep Existing Named Ranges

If checked, the existing named ranges will be kept, otherwise these will be unmarked as named ranges and only the found range will be a named range after this step.