Microsoft Office Tutorials and References
In Depth Information
19.3.36 Next and Previous Properties
The MergeCells property returns True if the specified range is contained within a merged range
of cells. The property returns Null if the specified range contains cells that are within a merged
range as well as cells that lie outside the merged range.
19.3.36 Next and Previous Properties
When applied to a Range object, the Next property returns the cell that would be made active by
striking the
TAB
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).
19.3.37 NumberFormat Property
This property returns or sets the number-formatting string for the cells in the range. Note that the
property will return Null if the cells in the range do not all have the same number format.
One of the simplest ways to determine the desired formatting string is to record an Excel macro
and use the Format dialog. You can then inspect the macro code for the correct formatting string.
19.3.38 Parse Method
This method parses the data in a column (or portion thereof) and distributes the contents of the
range to fill adjacent columns. The syntax is:
RangeObject .Parse( ParseLine , Destination )
where RangeObject can be no more than one column wide.
The ParseLine parameter is a string containing left and right brackets to indicate where the data
in the cells in the column should be split. For example, the string:
[xxx] [xxx]
causes the Parse method to insert the first three characters from each cell into the first column of
the destination range, skip the fourth character, and then insert the next three characters into the
second column. Any additional characters (beyond the first six) are not included in the destination.
This makes the Parse method most useful for parsing fixed-length data (each cell has data of the
same length).
The Destination parameter is a Range object that represents the upper-left corner of the
destination range for the parsed data. If this argument is omitted, Excel will parse the data in place;
that is, it will use the source column as the first destination column.
19.3.39 PasteSpecial Method
This method pastes data from the Clipboard into the specified range. The syntax is:
Search JabSto ::




Custom Search