Calculate amount of filtered tasks.

[Fred Sjoo]

Hi,

I am missing(can't find) the most fundamental function in
Project that summeries the amount of tasks for current
filter?

I just want to do simple a thing as amount of tasks
started within date range for example.

Thanks,
Fredrik

 

[Jan De Messemaeker]

Hi Fred,

It does not exist.
Following Macro will do the trick.

Do the following:
Alt+F11
In the left upper window, click ProjectGlobal
Insert, Module
Below Project Global, double-Click Module1 (or the highest numnber if there
are more ModuleN modules)
Paste the text below
Close the VBE window
Tools, Macro, Macros, select Count_Filtered

'----------------------------------------
Sub Count_Filtered
dim nbrt as integer
selectall
nbrt=activeselection.tasks.count
msgbox "Tasks Filtered: " & cstr(nbrt)
end sub
'------------------------------------------

HTH

 

[Steve House]

"Amount" as in the number of tasks or what? Just what values are you trying
to summarize?

 

[Guest]

Yep, number of tasks is what I'm after.

-----Original Message-----
"Amount" as in the number of tasks or what? Just what values are you trying
to summarize?


--
Steve House [MVP]
MS Project Trainer/Consultant
Visit http://www.mvps.org/project/faqs.htm for the FAQs





.

 

[Steve House]

LOL - Only thing I can think of is to apply your filter and then count the
tasks shown.


--
Steve House [MVP]
MS Project Trainer/Consultant
Visit http://www.mvps.org/project/faqs.htm for the FAQs