Don't forget also that when you use Excel, it is storing and updating
internal information all the time, so it has a whole bunch of information
that any user written routijne would probably have to determine. May not be
a big issue with say a simple SUM, but it could get critical in other areas,
such as determining the last value in a column.

There are so many reasons, which is why VBA should always be the last resort
IMO, never the first.

--

HTH

RP

"davidm" wrote in
message ...

because Excel uses compiled C code which is
much faster than VB or VBA

Many thanks Bob. You have confirmed my sneaking suspicion. I will
reserve a clarification on Compiled vs Interpreted language for another
time.

David


--
davidm
------------------------------------------------------------------------
davidm's Profile:
http://www.excelforum.com/member.php...o&userid=20645
View this thread: http://www.excelforum.com/showthread...hreadid=501971