This example illustrates the CurrentRegion property in Excel VBA. The current region is a range bounded by any combination of blank rows and blank columns. Can you find the current region of cell A1?

Place a command button on your worksheet and add the following code line:

Result when you click the command button on the sheet:

Here is another example. Can you find the current region of cell B3?

Code:

Result:

The value 1 in row 1 has no influence on the current region of cell B3. Row 2 is empty!