Object Not Set error for Blank Tasks

[roadkill]

I've tried both For Each...Next and Do...Loop in an effort to cycle through
all tasks in a series of projects and interrogate them for certain
conditions. However I haven't been able to figure out a way to avoid macro
termination caused by blank task (i.e. blank lines inserted into a schedule
to separate groups of tasks). I also tried the On Error statement in an
effort to skip over these blanks, but that didn't work either.

I recognize that removing the blanks would resolve the issue, but that may
be difficult to sell. Is there a way check each task yet avoid this error?

THE ERROR READS: Object variable or With block variable not set.

Thanks for the help,
Will

 

[Mike Glen]

Hi Will,

Try posting on the developer newsgroup. Please see FAQ Item: 24. Project
Newsgroups. FAQs, companion products and other useful Project information
can be seen at this web address: http://project.mvps.org/faqs.htm

Mike Glen
Project MVP

 

[Jan De Messemaeker]

Hi,

ANY for each should be followed by
If not thistask is nothing then
HTH

 

[roadkill]

That did it! Thank you for sharing you expertise.
- Will