View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Harker Norman Harker is offline
external usenet poster
 
Posts: 162
Default 1 Question (no work involved)

Hi seeya ste!

See:

Charles Williams:
http://www.decisionmodels.com/memlimitsc.htm

You'll see that the limits vary with Excel version but that Excel 2003
should be able to handle it.

You might also make your file size much smaller by making the used
range more efficient.

You might also make your code more efficient by using Rob Bovey's
CodeCleaner:

Stephen Bullen hosted (temporary location):
http://66.206.3.208/MVP/Default.htm

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia

Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
"ste mac" wrote in message
om...
Hi There,
I have a spreadsheet which stands right now at 118meg... it runs

fine,
I was going to make a move that would increase the file size to over
135meg or bigger, l am no-programmer and l use this ng for snippets
of code from the high flyers to use in my program...

My question is: when is too big actually too big? does it depend on

the
machine? or will Excel just give in at some stage?

thanks

seeya ste