Home > Articles > Home & Office Computing > Microsoft Applications

This chapter is from the book

Using the CurrentRegion Property to Select a Data Range

CurrentRegion returns a Range object that represents a set of contiguous data. As long as the data is surrounded by one empty row and one empty column, you can select the data set by using CurrentRegion:


The following line selects A1:D3 because this is the contiguous range of cells around cell A1 (see Figure 3.5):

Figure 3.5

Figure 3.5 Use CurrentRegion to select a range of contiguous data around the active cell.

This is useful if you have a data set whose size is in constant flux.

  • + Share This
  • 🔖 Save To Your Account