Skip to content

Instantly share code, notes, and snippets.

@ndthanh

ndthanh/heo_access_worksheet.bas

Created December 27, 2016 14:54
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/5b5ebb59b731f60ec69b3709d6c4af41 to your computer and use it in GitHub Desktop.
Save ndthanh/5b5ebb59b731f60ec69b3709d6c4af41 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
heo_access_worksheet.bas
'https://www.hocexcel.online/vba-excel-doi-tuong-workbooks-worksheets-ranges.html
'dtnguyen | Học Excel Online
'Tham chiếu đến Sheet trong Workbook hiện
ThisWorkbook.Worksheets("[tên sheet]")
'hoặc sử dụng codename, ví dụ: Sheet1
'Tham chiếu đến Sheet trong 1 workbook cụ thể
wk.Worksheets("[tên sheet]")
'Tham chiếu đến Sheet hiện thời
ActiveSheet
'Sử dụng worksheet với biến
Dim sh as Worksheet
Set sh = wk.Worksheets("[tên sheet]")
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment