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

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

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

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

Darre

--
DarrenWoo
-----------------------------------------------------------------------
DarrenWood's Profile: http://www.excelforum.com/member.php...fo&userid=1646
View this thread: http://www.excelforum.com/showthread.php?threadid=38332

No worrys guys I have solved this one myself. Just added a line to sa
if no file found to end sub !

So easy when you find the answer!

--
DarrenWoo
-----------------------------------------------------------------------
DarrenWood's Profile: http://www.excelforum.com/member.php...fo&userid=1646
View this thread: http://www.excelforum.com/showthread.php?threadid=38332