• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Chapter 19. The Range Object

The Range object is one of the workhorse objects in the Excel object model. Simply put, to work with a portion of an Excel worksheet, we generally need to first identify that portion as a Range object.

As Microsoft puts it, a Range object “Represents a cell, a row, a column, a selection of cells containing one or more contiguous blocks of cells, or a 3-D range.”

Table 19-1 shows the 158 members of the Range object.

Table 19-1. Members of the Range Object

_Default

End

Phonetic

_NewEnum


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint