通过

Application.SelectTimescaleRange Method

  • 项目
Project Developer Reference

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

Syntax

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

expression   A variable that represents an Application object.

Parameters

Name Required/Optional Data Type Description
Row Required Long The number of the row containing the cell to select.
StartTime Required String 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.

Return Value
Boolean

Example
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.

Visual Basic for Applications 
  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

See Also