General Question

  • Thread starter Thread starter Squid
  • Start date Start date
S

Squid

Does using code versus using worksheet functions minimize
both the size of the file and system resources?
 
You may make the workbook a bit smaller, but you will almost
certainly greatly increase the calculation time.

Another factor to consider though is maintenance.
No one is going to work easily with two hundred byte formulas with
nesting. If you do what you need easily with Worksheet Formulas
using builtin Excel functions you are ahead of the game.

Slow Response
http://www.mvps.org/dmcritchie/excel/slowresp.htm
 
Might also add that a long function name is probably going to
reduce to about one byte or two bytes for a function name.
Just my opinion -- not based on any documentation.

The fact that a workbook can be use in languages other
than English is also a pretty good indication that something
other than the words are used in Worksheet Functions.
 
The workbook size is not much of an issue, it is under
350K. The problem I was running into was the message "Not
enough system resources to display completely" (see my
posting in misc with that heading).

But will try changing integer to Long in my code, removing
unused add-ins and make sure the users dont have extra
stuff running in the background.

Thanks!
Mike
 
Back
Top