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

you have to use "on error resume next"

say

just before the line where you are getting error type in:
on error resume next 'this code before error line

'code
'code

last line after error, type in:

if(err.description<"") then 'this code after error line
err.clear()
end if


If you are not clear about this, paste your code, I can add exceptio
handling to it

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

Can it be handled sure. But my question is if you are blowwing through the
65,536 limit would your data be better suited to a database than to a
spreadsheet. The performance on the spreadsheet you are creating is going to
be exceptionally poor (possibly to the point of crashing Excel). If you put
the data in a Database you can query out what you need into a spreadsheet of
pivot on external data, both which have very good performance and require no
coding. Benefits of a database a

No limit on the number of records (ish)
Multiple concurrent users
Good performance

--
HTH...

Jim Thomlinson


"dtguitarfan" wrote:


Hi Guys,
I have made a macro which will open all the excel spreadsheets in a
directory I point it to and copy all the worksheets to one master
worksheet. I have a bunch of excel spreadsheets that are formatted in
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 and
after copying from a few of the excel documents to that sheet it gets
too big, and my macro throws and exception and will not continue. Is
there a way that I can test for this and handle this exception so that
when it gets to the point that this sheet is too big it just skips over
that one and continues with the others?
Geoff


--
dtguitarfan
------------------------------------------------------------------------
dtguitarfan's Profile: http://www.excelforum.com/member.php...o&userid=24403
View this thread: http://www.excelforum.com/showthread...hreadid=380613