This action retrieves the starting row/column and ending row/column of the cell range currently selected by the Excel book.
How to use.
Specify the target file in Launch Excel Action or Attach Running Excel Action and drag Get selected cell range from Excel worksheet Action from Excel to the Workspace.
Set parameters.
Parameters
Excel instance
Specify the target Excel file.
Specify the Variables produced for the Launch Excel Action or the Attach to running Excel Action.
Variables produced
The selection is stored as a result of the action.
For example, for the following selection.
| Variable | Value |
|---|---|
| FirstColumnIndex | 3 |
| FirstRowIndex | 2 |
| LastColumnIndex | 5 |
| LastRowIndex | 7 |
On error
Error handling is performed as needed.
If the acquisition fails for any reason, an error occurs.
For those who want to learn Power Automate Desktop effectively
The information on this site is now available in an easy-to-read e-book format.
Or Kindle Unlimited (unlimited reading).
You willl discover how to about basic operations.
By the end of this book, you will be equipped with the knowledge you need to use Power Automate Desktop to streamline your workflow.