Conflict between VBA and worksheet functions?

C

cogman

Joined
Jan 30, 2007
Messages
1
Reaction score
0
To avoid including a reference to the atpvbaen.xls file, I created a public function called Workday() in a module for a spreadsheet. I have since deleted this function from the spreadsheet and it seems to be causing a problem with the WORKDAY() function in the worksheets. Formulas that have already been written work OK, but if I write a new one including this function, I get the #NAME? error messgae. I have tried restarting excel and removing and reinstalling the Analysis ToolPak AddIn but it still doesn't work.

Has anyone had this problem before?

Thanks

John
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unable to access complex arithmetic functions in VBA for Excel 200 1
Workday Function in VBA 3
Using IsBlank in VBA 5
Analysis Toolpak in multilangual version 6
Using add-in functions on a form 2
Showing argument descriptions as an XLL worksheet function is type 1
Create Range by joining multiple Ranges - passing multiple holidayranges to Workday function 6
Conflicting functions 0

Back
Top