First of all I want to admit that I have no idea about VB codes...
Now coming to the point --- I have a VB code which basically creates functions of erlangb and erlangc in excel.
These functions are used to forecast the call volume, utilization and required manpower in contact centers.
As I stated I have no "idea" of VB codes so I simply copied and pasted the VB code(in attachment) and tried to become a "hero" . But it is giving me error i.e. Marco parse failed. Functionality was lost.
However the same VB code is working fine in Excel
It will be great if someone could help me in understand what am I doing wrong and how to make this work.