Get Last Column Index
=====================

Category
--------
Excel Commands

Description
-----------

This command allows you to find the last column in a used range in an Excel Workbook. Use this command to determine how many columns 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 Column Index\\Get Last Column Index.xml`

See Also
--------
	- :doc:`Add Workbook <exceladdworkbook>`
	- :doc:`Add Worksheet <exceladdworksheet>`
	- :doc:`Append Cell <excelappendcell>`
	- :doc:`Append Row <excelappendrow>`
	- :doc:`Close Workbook <excelcloseworkbook>`
	- :doc:`Copy Worksheet <excelcopysheet>`
	- :doc:`Delete Cell <exceldeletecell>`
	- :doc:`Delete Row <exceldeleterow>`
	- :doc:`Excel Create Datatable <excelcreatedataset>`
	- :doc:`Export to PDF <excelexporttopdf>`
	- :doc:`Get Cell <excelgetcell>`
	- :doc:`Get Cell Style <excelgetcellstyle>`
	- :doc:`Get Last Row Index <excelgetlastrow>`
	- :doc:`Get Range <excelgetrange >`
	- :doc:`Get Range As Datatable <excelgetrangeasdt>`
	- :doc:`Get Worksheets <excelgetworksheets>`
	- :doc:`Go To Cell <excelgotocell>`
	- :doc:`Insert Cell <excelinsertcell>`
	- :doc:`Lookup Range <excellookuprange>`
	- :doc:`Open Workbook <excelopenworkbook>`
	- :doc:`Remove Duplicate <excelremoveduplicate>`
	- :doc:`Run Macro <excelrunmacro>`
	- :doc:`Save Workbook <excelsave>`
	- :doc:`Save Workbook As <excelsaveas>`
	- :doc:`Set Range <excelsetcell>`
	- :doc:`Write Range <excelwriterange>`
	- :doc:`Write Row <excelwriterow>`