Is there a way to "compile" a user function to make it run faster and with less chance of bombing

I amd writing several user functions used in the same file and they seem to slow down as you ad more to the file. Is there a way to make them act like "true" functions and run faster and cleaner

Peter

Peter,

No, there isn't a way to compile functions in order to increase
speed or reliability. The best approach is a well designed
algorithm in the first place.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Peter JW" wrote in message
...
Is there a way to "compile" a user function to make it run
faster and with less chance of bombing?

I amd writing several user functions used in the same file and
they seem to slow down as you ad more to the file. Is there a
way to make them act like "true" functions and run faster and
cleaner?

Peter