SelectTimescaleRange Method

Selects one or more timescale data cells in a usage view.

Syntax

expression**.SelectTimescaleRange(Row, StartTime, Width, Height)**

*expression   *     Optional. An expression that returns an Application object.

Row Required Long. The number of the row containing the cell to select.

StartTime Required Variant. A time (from the timescale) that functions as the starting point of the selection.

Width Required Integer. The number of columns to select.

Height Required Long. The number of rows to select.

The following example selects a five-day range of timescale data cells for the specified row. It assumes the timescale has not been changed from the default setting. The SelectRow method is not required for this example, but is included to make the result easier to read.

Example

Sub SelectWeek()
    Dim WhichRow As Integer, StartDate As Variant
    
    WhichRow = InputBox("Start selection on which row?")
    StartDate = InputBox("Enter the date for the start of a week: ")
    
    SelectRow WhichRow, False
    SelectTimescaleRange Row:=WhichRow, StartTime:=StartDate, Width:=5, Height:=1
    
End Sub

Applies to | Application Object

See Also | SelectRange Method | TimeScaleData Method | TimeScaleValue Object, TimeScaleValues Collection Object