Applying a macro to multiple sheets

Leith Ross gave me a solution to adjusting Barrier positions for Non-starters. I didn't think to include the fact that it had to be applied to multiple worksheets. His solution works perfectly, but when I try to run it over multiple sheets, it reduces the lowest barrier position by 1 for each sheet that has a non starter and has been previously processed by the macro. The result in the attached example is that by race 9, barrier position 1 has become -5. Leith's code is in module 1 and called "UpdatePositions". My attempt is called "UpdateBarriers" in module 2.

One other problem with my attempt is that when a race has no starters in it, the macro stops working, rather than completing the outside "For" statement.

Any assistance on these issues will be greatly appreciated.

Steve W

hi, swallis, I did not go into the code logic, just added loop for the sheet with number names

Please Login or Register  to view this content.