Next and Previous Properties

When applied to a Range object, the Next property returns the cell that would be made active by striking the

key, although it does not actually select that cell. Thus, on an unprotected sheet, this property returns the cell immediately to the right of the upper-left cell in the range. On a protected sheet, this property returns the next unlocked cell.

Similarly, the Previous property emulates the Shift-Tab key by returning the appropriate cell (also without selecting the cell).

0 0

Post a comment