I suggest an experiment.

Take of copy of the workbook and do whatever you do to increase the size.
Keep increasing it until Excel or the machine gives up. You might be
surprised at what Excel can do with your resources. If the machine gives up
first, try running the workbook on a machine with bigger resources.
Sometimes it's a lot cheaper to add some more RAM or to add a larger
hard-disk than it is to put the effort into programming.

The point of this experiment is so you know just how far you can take it
without having to think about re-designing the application.

--
Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"



"ste mac" wrote in message
om...
Hi Andy, thanks for your reply, the reason it is so large is due to the
amount of data the wb is holding, if l could program for real (like some
of the people here) it could probably be made a bit smaller..
The app works fine, it takes around 8 sec's to open and runs fine..
My question was asked to see if someone knew what the 'limit' was in
Excel (if there is any)l have been constantly using this app for over
a year without any problems, l was just wondering when/if it was getting
too big...
I have 1 gig memory, 40 gig HD and not very much patience(<g)

seeya ste