Get Last Column Index

Get the index of the last used column.

ExcelExcelGetLastColumnIndex

What it does

Get the index of the last used column.

Parameters

ParameterTypeRequiredDefaultDescription
Excel instancevariable
RequiredexcelName that identifies this open workbook.
Sheet (blank = active)string
OptionalWorksheet name; blank uses the active sheet.
Supports variables
Store column index invariable
Required
Example: lastCol

More Excel commands

Ready to automate your busywork?

Start your free 10-day trial today. No credit card, no commitment.