Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    May 2005
    Thanked 0 Times in 0 Posts

    Function Troubles (Excel)

    Hi All,

    I have made a function which calculates a space factor for me on pressure and temp. THe problem is I cant get the function to work.

    and ideas out there will help.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Function Troubles (Excel)

    You don't have Option Explicit at the top of your module, and that is very dangerous. If you had had that, you'd have been warned that your function refers to variables Ps and Tc that haven't been declared and haven't been assigned a value. Hence the calculation fails.

    Note: if you tick 'Require Variable Declaration' in Tools | Options... in the Visual Basic Editor, Option Explicit will be inserted into new modules automatically. You'll have to add it to existing modules by hand.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts