I have written a macro that opens up a worksheet from a named individual ( the name of the worksheet is the individuals name ) that has been e mailed to me and it then proceeds to 'cut and paste' the data from the source sheet to my master sheet. Once completed that particular macro ends and the next one starts and that looks for the next persons sheet to copy.

The problem I have is that when anyone of the individuals do not send me their sheet, the macro assigned to them cannot find the sheet and I get a 'Run time error 9 Subscipt out of range ' message because clearly it cant find the sheet it is looking for.

Is there any way of preventing this message popping up and instead the macro merely ends and moves on to the next macro which will look for the next persons sheet ?

Any comments are very much appreciated, unfortunately the macros are on a different pc and i cannot copy them onto here to show you but i think it is clear what i am trying to do.

Darren