Almost certainly not. Just the overhead involved in a VB call generally
makes UDF unattractive for functions that can be performed on the
worksheet.

Take a look here for tips on speeding things up:

http://www.decisionmodels.com/optspeed.htm



In article ,
John Contact wrote:

Hi,

I have a number of ormulas that are performing rather slowly, calculation of
the workbook takes approximately 2 minutes. My question is, if they were re
written to calculate in vb would this speed things up?

Thanks in advance

John