Macro in Custom Field not working for Sub Projects

[noviceScheduler]

Hi all.



I have an integrated schedule - Master Schedule with 8 Subprojects that. I have a macro in MS Project that copies a custom Task field to a custom Resource Field (Text 2 from Task to Resource field).

My issue is that the code is only working for the master schedule tasks, they're not working for tasks that are in "Sub Projects". I need the macro to copy the same fields for all the tasks in the integrated schedule including the "Sub Project" tasks.

Keeps on prompting me with "Run-time error 1001"

Ps help...

thank you.

[DaleHowardMVP]

I think you need to add the following VBA code to your macro to account for each subproject in the master project:

Dim SubProj As Subproject

For Each SubProj In ActiveProject.Subprojects


Next SubProj

Give it a try and let us know if it helps.