how to pass arguments and variables common to many functions

Posted on 2011-05-07
Last Modified: 2012-05-11
i have a spreadsheet that i have used for years that has a few modules of code and lots of excel formulas.  i need to add some new tables to it and the complexity is to great for just formulas.  i have written code for 1 cell that works.  when i tried to do a very similar thing for another cell it worked but the first cell i programmed does not return a value any more.  both functions have an argument and some common variables so they must be interfering with each other.  the first cell's function is called tmr and the 2nd is called caxwf.  thanks.
Question by:kalbano
    LVL 43

    Accepted Solution

    For the TMR change the module name to something different from the sub name.

    For the caxwf use the formula

    =IF(C25 ="",1,CAX_WF(26))

    instead of

    =IF(C25 ="none",1,CAX_WF(26))

    Author Closing Comment

    Thanks!  Forgot that module name cant be function name.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Suggested Solutions

    A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
    MS Access 2003 or later To MySQL Migration Project Hello All, this is my second article in the category of MS-OFFICE Automation. In internet I am not able to find any comprehensive resource on the Migration of MS Access back-end to MySQL so I fin…
    This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now