Get Last Row Index

Category

Excel Commands

Description

This command allows you to find the last row in a used range in an Excel Workbook. Use this command to determine how many rows have been used in the Excel Workbook. You can use this value in a **Number Of Times** Loop to get data.

Parameters

Instance Name

Enter the instance name to indicate the selected workbook

Sheet Name

Indicate the name of the sheet within the Workbook to activate

Column Letter

Letter of the Column to check (ex. A, A:G). If input is Letter + Number, it returns the max row of that column letter. If input is Letter + Number : Letter + Number, it returns the minimum between the last row and the input Number.

Variable

Assign result to variable

Returned Value

This command does not have returned value.

Example Usage

Example Location:

BYpass\Examples\Excel Commands\Get Last Row Index\Get Last Row Index.xml

See Also

• Add Workbook

• Add Worksheet

• Append Cell

• Append Row

• Close Workbook

• Copy Worksheet

• Delete Cell

• Delete Row

• Excel Create Datatable

• Export to PDF

• Get Cell

• Get Cell Style

• Get Last Column Index

• Get Range

• Get Range As Datatable

• Get Worksheets

• Go To Cell

• Insert Cell

• Lookup Range

• Open Workbook

• Remove Duplicate

• Run Macro

• Save Workbook

• Save Workbook As

• Set Range

• Write Range

• Write Row