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