Get a Row
Gets a row from an Excel worksheet that contains a specific value.
Overview
This procedure locates and retrieves a row in an Excel worksheet that contains a specific value. A column or a row number can be specified to identify the row.
Syntax
Below is a line-by-line overview of the automation syntax. Expand each line to learn more.
Examples
1. Get a Row by Specifying a Row Number
get the worksheet's row
the row number is 23
2. Get a Row by Specifying a Column Label and Cell Value
get the worksheet's row
the column label is "AB"
the cell value is "Total:"
Last updated
Was this helpful?