Get Last Column in Row

Beginner

Finds the last used column in a specific row of the active worksheet.

VBA Code

Sub GetLastColumn()
  Dim lastCol As Long
  lastCol = Cells(1, Columns.Count).End(xlToLeft).Column
  MsgBox "Last column in row 1: " & lastCol
End Sub

RELATED MACROS IN DATA ANALYSIS

Beginner Macros

Get Last Row in Column

Finds the last used row in a specific column of the active worksheet.

Sub GetLastRow()
  Dim lastRow As Long
  lastRow = Cells(Rows.Count, "A").End(xlUp).Row
  MsgBox "La...