Current Region Property

This useful property returns a Range object that represents the current region, which is the region bound by the closest empty rows and columns. To illustrate, the following code, when applied to the sheet in Figure 19-11, selects the rectangular region A2:C4:

ActiveCell.CurrentRegion.Select

Figure 19-11. Illustrating CurrentRegion

A

B | C D

1

2

1

2

□ I

4

3

4

5

6 7

5

S 7

0 0

Post a comment