Tabellab
Beginner

Ranges & Cells

Point your code at exactly the right cells and read or write them without ever clicking.

8 lessons 56 min Certificate

The first lesson is free — no account needed.

About this course

Everything a macro does starts with the VBA Range object. You learn Range and Cells(row, column), why referencing beats selecting, reading and writing values, moving with Offset and Resize, CurrentRegion and UsedRange, finding the last row reliably and always naming the sheet you mean.

Lessons

  1. The Range ObjectReading10 minFree
  2. Cells(row, column)Reading6 min Pro
  3. Selecting vs ReferencingReading7 min Pro
  4. Reading and Writing ValuesReading7 min Pro
  5. Moving Around with Offset and ResizeReading6 min Pro
  6. CurrentRegion and UsedRangeReading7 min Pro
  7. Finding the Last RowReading7 min Pro
  8. Being Explicit About the SheetReading6 min Pro