Skip to content

Latest commit

 

History

History
61 lines (38 loc) · 1.69 KB

Project.Application.SelectTimescaleRange.md

File metadata and controls

61 lines (38 loc) · 1.69 KB
title keywords f1_keywords ms.service api_name ms.assetid ms.date ms.localizationpriority
Application.SelectTimescaleRange method (Project)
vbapj.chm954
vbapj.chm954
project-server
Project.Application.SelectTimescaleRange
16a4bd12-7a60-c172-6a73-c3552b2baf4b
06/08/2017
medium

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

[!includeSupport and feedback]