Worksheets & Workbooks
Point your code at the right sheet and the right file, every single time.
The first lesson is free — no account needed.
About this course
Point your code at the right sheet and the right file every time. You work with the VBA Worksheet and Workbook objects: referencing sheets safely, adding, copying and deleting sheets, ThisWorkbook versus ActiveWorkbook, Workbooks.Open, SaveAs and Close, looping through sheets, and visibility and protection.