- 01Setting up (what you'll need)
- 02Your first output (MsgBox)
- 03Variables (Dim)
- 04Branching (the If statement)
- 05Repeating (the For statement)
- 06Repeating (the Do While statement)
- 07Writing a Sub procedure
- 08Function procedures (work that returns a value)
- 09Reading and writing cells (Range and Cells)
- 10Working with arrays
- 11Working with strings
- 12The With statement
- 13Object variables and working with worksheets
- 14Looping over cells (For Each)
- 15Error handling (On Error)
- 16The Select Case statement
- 17Arguments (ByVal and ByRef)
- 18Working with collections (Collection)
- 19Recording macros and event procedures
- 20[Project] Build a small inventory sheet
Object variables and working with worksheets
This lesson covers holding a sheet in an object variable.
You declare it with Dim name As Worksheet and assign a particular sheet with Set name = Worksheets("SheetName"). Watch out for the Set — it is easy to leave out.
The sample code declares Dim ws As Worksheet, assigns a sheet with Set ws = Worksheets("Sheet1"), and then reaches cells as ws.Range("A1").
A common early stumble is forgetting Set when assigning an object. Unlike assigning a number or a string, putting an object into a variable always needs Set.
In professional work, holding sheets in object variables keeps macros that juggle several sheets much tidier.
๐งช This site can't compile or run VBA directly, so it checks on the spot whether what you typed matches the reference code (scoring happens entirely in your browser โ nothing is sent anywhere).