Thank you so much for all your help with this....I guess I'm not versed enough in even basic vba to get the module placement right. I did a search and replace on one of the scripts that you put together replacing Switches with SWITCHES and the other SWITCHES1...added them to the VB code as Module1 and Module2. Now the cell registers as #NAME? I can't get it to work anymore... How can I make the scripts work for both scenerios?
Thanks again,
Anne
You will need to post an example wherein you have placed your code - and where #NAME? errors are being generated...
Note you can only have one function called SWITCHES else you will get an ambiguity error ie Switches and SWITCHES are one and the same as far as XL is concerned - this error will result in a #NAME? evaluation.
If however the functions are stored in Modules in a macro-enabled VBA file you should find calling SWITCHES1 / SWITCHES should work without issue.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Here's some screen shots of the trouble...Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks