Resource.Group property (Project)
Gets or sets the group to which a resource belongs. Read/write String.
expression A variable that represents a Resource object.
The following example deletes the resources in the active project that belong to a group specified by the user.
Sub DeleteResourcesInGroup() Dim Entry As String ' The group specified by the user Dim Deletions As Integer ' The number of deleted resources Dim R As Resource ' The resource object used in loop ' Prompt user for the name of a group. Entry = InputBox$("Enter a group name:") ' Cycle through the resources of the active project. For Each R in ActiveProject.Resources ' Delete a resource if its group name matches the user's request. If R.Group = Entry Then R.Delete Deletions = Deletions + 1 End If Next R ' Display the number of resources that were deleted. MsgBox(Deletions & " resources were deleted.") 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.