Callable from VBA

• All Business Functions are easily callable from VBA, so you can use them either for your own custom functions or within a macro.
• Example Custom Function:

  Function RentAndFitout(Time,Base,fitout,FromDates,Rents,Expiry,MktRent,GrowthDates,GrowthRates)
  Dim myrent, myfit
  myrent = Run("fsteprentgrow",Time,Base,Expiry,MktRent,FromDates,Rents,GrowthDates,GrowthRates,60,0,6,4,1)
  myfit = Run("mkpmts",Time,Base,FromDates(1),fitout)
  RentAndFitout = myrent - myfit
  End Function

• You can also do this with Array functions.
• You will suffer a performance penalty if you use VBA - the above example is 4 times slower than using the 2 'native' Business Functions in a cell.