Excel VBA Programming The Complete Guide - The Range.Row and Range.Column Properties

The video tutorial explains how to use row and column properties in VBA for a range object. It demonstrates with a simple example using cell C4, showing how to access column and row properties. The tutorial further explores what happens when the range is expanded to a larger area, like C4 to J26, and clarifies that the values are relative to the entire worksheet, not just the range. The video concludes by noting that VBA uses the top-left cell of the range as the reference point for calculations.

What type of data do the row and column properties return?

• String

• Boolean

• Long

• Double

In the example with cell C4, what is the column number returned by the column property?

• 4

• 3

• 1

• 2

When expanding the range from C4 to J26, what remains constant?

• The reference point

• The column number

• The range size

• The row number

How does VBA determine the column and row numbers for a range?

• By the size of the range

• By the bottom-right cell of the range

• By the top-left cell of the range

• By the number of cells in the range

What is the relationship of the column and row numbers to the worksheet?

• They are relative to the selected cells

• They are relative to the workbook

• They are relative to the worksheet

• They are relative to the range