Skip to content

Instantly share code, notes, and snippets.

@thoriqmacto

thoriqmacto/[VBA] Lastrow

Last active January 10, 2021 13:34
Show Gist options
  • Save thoriqmacto/0346a438c04fc9f7bec2 to your computer and use it in GitHub Desktop.
Save thoriqmacto/0346a438c04fc9f7bec2 to your computer and use it in GitHub Desktop.
Download ZIP
find lastrow using vba
Raw
[VBA] Lastrow
'For columns which has non-blank cells
Range("A" & Rows.Count).End(xlUp).Row
'For columns which has active cells
Range("A1").SpecialCells(xlCellTypeLastCell).Row
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment