A VBA snippet on how to get the last row and column in the worksheet.

Xybernetics Excel - Get Last Row And Column

Here is the code so that you don’t have to type.

[sourcecode language=”csharp”]
Private Sub GetLastRowNCol()
‘ The number 1 in this statement means Column 1
lngLastRow = Cells(Rows.Count, 1).End(xlUp).Row
‘ The number 4 in this statement means Row 4
lngLastCol = Cells(4, Columns.Count).End(xlToLeft).Column

MsgBox lngLastRow & " | " & lngLastCol</code></pre>
End Sub

[/sourcecode]

n1849778
About the
I am a software developer in Calgary, Alberta, Canada with passion in getting my fingers in any new technology. I started software development when I was 10 years old and have never looked back. Now with well over 35 years of software development, I wanted to share some of these key knowledge with the people of the world in the wide web.