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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.