CostRateTables Collection Object

  • Article
Project Developer Reference

Contains a collection of CostRateTable objects.

Example

Using the CostRateTables Collection

Use the CostRateTables property to return a CostRateTables collection. The following example lists the standard pay rates for all the cost rate tables of the resource in the active cell.

Visual Basic for Applications 
  Dim CRT As CostRateTable, PR As PayRate
Dim Rates As String

For Each CRT In ActiveCell.Resource.CostRateTables
For Each PR In CRT.PayRates
Rates = Rates & "CostRateTable " & CRT.Name & ": " & PR.StandardRate & vbCrLf
Next PR
Next CRT


MsgBox Rates

See Also