Hi Guys,
I have made a macro which will open all the excel spreadsheets in
directory I point it to and copy all the worksheets to one maste
worksheet. I have a bunch of excel spreadsheets that are formatted i
exactly the same way, so my macro just takes them and combines them.
My problem is that one of the worksheets has a lot of information an
after copying from a few of the excel documents to that sheet it get
too big, and my macro throws and exception and will not continue. I
there a way that I can test for this and handle this exception so tha
when it gets to the point that this sheet is too big it just skips ove
that one and continues with the others?
Geof

--
dtguitarfa
-----------------------------------------------------------------------
dtguitarfan's Profile: http://www.excelforum.com/member.php...fo&userid=2440
View this thread: http://www.excelforum.com/showthread.php?threadid=38061