Thread: [Solved] Total Resources
View Single Post
 
Old 10-04-2010, 09:04 AM
Kimberly Kimberly is offline Windows 7 Office 2010 (Version 14.0)
Expert
 
Join Date: May 2010
Posts: 517
Kimberly is on a distinguished road
Default

Add the field Number 1 to a table.

Use the following custom function:
Sub ResCount()
Dim t As Task
For Each t In activeproject.Tasks
If Not t Is Nothing Then
t.Number1 = t.Assignments.count
End If
Next t
End Sub
Reply With Quote