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
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Squid" wrote in message ...
Does using code versus using worksheet functions minimize
both the size of the file and system resources?

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


-----Original Message-----
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.


.