Get Selected Range

• Workbook file - The file from which a specific range should be retrieved.

• Save to - The Range variable that is retrieved. The selection applies only to the active sheet and requires Excel to be opened. Also, the option should return a Range and not a String.

Common

• DisplayName - The display name of the activity.

• Target Workbook - The workbook from which to get the selected range. The field is automatically populated when the activity is created inside a Use Excel File context.

Misc

• Private - If selected, the values of variables and arguments are no longer logged at Verbose level.

Output

• Range - The retrieved range, stored in a String variable. This field supports only strings and String variables.

  Note: Get Selected Range activity can be used as a confirmation tool or as an information extractor tool.

  • Confirmation tool: when used together with the Select Range activity, the Get Selected Range activity confirms the automatically selected range.
  • Information Extractor Tool: when used as a standalone activity, Get Selected Range extracts the information and notifies the user about the manually selected range.