#NAME? with user-defined formula (VBA Project)

  • Thread starter Thread starter Hannes
  • Start date Start date
H

Hannes

I downloaded a VBA project from the internet (CallPremium) and saved it to
Visual Basics. The website said, in order for the function to work, I needed
to install "Analysis ToolPak", which I did as well. Now when I try to use the
public function I get a #NAME? error. Any ideas anyone?

Hannes
 
You may need to install in both the worksheet as well as VBA. From the VBA
window:

Tools > References and check the atpvbaen.xls checkbox.
 
Back
Top