User Functions Compilation?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 said:
Is there a way to "compile" a user function to make it run
Click to expand...
faster and with less chance of bombing?
I amd writing several user functions used in the same file and
Click to expand...
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?
 
Back
Top