In MSP 2010 it is unfortunately not possible to apply a filter and then selectively expand a summary task to see the tasks that sit under that summary that were filtered out.
Someone else asked for a solution to this question in this thread here
The solution is to use VBA, but I have very little knowledge of VBA and don't know how to make the code work.
This is the suggested code
Dim tsk As Task
For Each tsk In ActiveProject.Tasks
If tsk.Summary = True Then
' Dim s As Integer
' s = tsk.ID
If tsk.PercentComplete >= 100 Then
I am able to open the VBA window and paste in this code, but when I try to run it I get a pop up saying Run-time error 91 Object variable or With block variable not set.
What am I doing wrong?