Skip to content

Instantly share code, notes, and snippets.

@ndthanh

ndthanh/used_range_last_row.bas

Created November 22, 2017 07:49
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ndthanh/4ef2674eddfffde74780591fd8f94428 to your computer and use it in GitHub Desktop.
Save ndthanh/4ef2674eddfffde74780591fd8f94428 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
used_range_last_row.bas
'dòng cuối cùng được sử dụng
jLastUsed = oSht.UsedRange.Rows(oSht.UsedRange.Rows.Count).Row
'
'dòng cuối cùng được sử dụng và không bị ẩn
jLastVisibleUsed = oSht.Cells.SpecialCells(xlCellTypeLastCell).Row
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment