Selection not updating after 1st iteration in a For Each loop

[Excel_vba]

The first line of the IF statement appears to be caught in the first iteration of the loop. The selection object doesn't seem to update with each iteration. The other lines do appear to update.

Is there a problem using the FIND method inside of a FOR EACH loop? I am thinking that the selection object needs to be deactivated somehow before the end of each iteration.

Any thoughts?

Please Login or Register  to view this content.

[pike]

Hi Excel_vba
As far a I can see it does loop but keeps finding the first "TOTAL COSTS"

[davesexcel]

Not sure what is supposed to happen,
Try This

Please Login or Register  to view this content.