Application.SelectTimescaleRange Method (Project)
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.
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