How to move to next sheet if Name is not present within sheet name

Hi All,

I am looking for some help on this issue?
I a spreadsheet "DBMileage" I have mileage by drivers, I want to add the mileage by each day for one week to a "Master" file. Each sheet name on the master file has the drivers name and is the same as the drivers name on the "DBMileage" sheet.
So, at present the code I have will add mileage to each sheet, but only if the drivers name is present, if the code finds a drivers name that is not on the spreadsheet, I receive a subscript error that the drivers name is not on the master.
How do I add this part into the code to say if the drivers name is not on the spreadsheet tab, move onto the to next sheet?
Thanks

Please Login or Register  to view this content.

I have attached the two demo files pretty much stripped down to only the relevant data needed.
Thanks

You can intercept the "Subscript out of range" error with On Error Resume Next and evaluating Err.Number.
If that's not zero then something isn't OK. Or if Err.Number is 9 then it's the "Subscript out of range" error.
In that case you make the code jump to the next name/sheet.
Make sure Error Trapping is set to "Break on unhandled errors". See Tools -> Options -> General

Thanks to you both for the prompt reply!!
Tsjallie, I am learning VBA and this has helped me a lot, I will remember this!

Fluff13, your code modifications has done the trick and works as requested.
Thanks to you both!