Get multiple cells action in Microsoft 365 Excel

Use the Get multiple cells action in Microsoft 365 Excel to retrieve the values of multiple cells within a worksheet and assign the output to a variable.

Settings

  • Enter the name of the session used to open the workbook with the Open action.
  • Select either the Multiple cells or All cells option. If you select Multiple cells, enter the cell range. For example, if you enter A1:D1,values of the first four cells in the top row are retrieved.
  • Assign the output to a String variable. To convert the string to a number, use the String > To number action. See To number action.