Skip to content

Instantly share code, notes, and snippets.

@ndthanh

ndthanh/last_row_range.find.bas

Created November 22, 2017 07:59
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/8f9b069324cf98b92ac2cd7bfc92b661 to your computer and use it in GitHub Desktop.
Save ndthanh/8f9b069324cf98b92ac2cd7bfc92b661 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
last_row_range.find.bas
'
'
jLastRangeData = oSht.Range("NamedRange").Find(What:="*", LookIn:=xlFormulas, SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row
'
'
jLastVisibleRangeData = oSht.Range("NamedRange").Find(What:="*", LookIn:=xlValues, SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row
'
'
jLastTableData = oSht.ListObjects("Table1").Range.Find(What:="*", LookIn:=xlFormulas, SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row
'
'
jLastVisibleTableData = oSht.ListObjects("Table1").Range.Find(What:="*", LookIn:=xlValues, SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment