Skip to content

Instantly share code, notes, and snippets.

@ndthanh

ndthanh/xlUp_xldown_table

Created November 22, 2017 07:55
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/9bc9f626504e6ac5a397fc1bc9ab666d to your computer and use it in GitHub Desktop.
Save ndthanh/9bc9f626504e6ac5a397fc1bc9ab666d to your computer and use it in GitHub Desktop.
Download ZIP
Raw
xlUp_xldown_table
'
' End(xlUP) sẽ trả lại kết quả khác với Table
'
jLastInTable2 = oSht.Range("Table1").Offset(oSht.Range("Table1").Rows.Count + 1, 0).End(xlUp).Row
'
' End(xlDown)
'
jLastVisibleTable = oSht.Range("Table1").End(xlDown).Row
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment