Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2006

    Unanswered: using vba for a formula in xl

    i would like to have a formula that reads a vba function
    some thing like

    =varAnaly(rng1 as range,rng2 as range,proof as range)

    function varAnaly
    if range(rng1) is a number ' is there a NAN in VBA?
    and if range(rng2) is a number then

    test1 = (range(rng1).value + range(rng2).value ) /2

    varAnaly = (test1- proof)/proof

    end func

    i am having trouble with if its a # and how to write a vba function and use it as an excel formula

  2. #2
    Join Date
    Mar 2006
    Take a look at the IsNumeric VBA function, it'll return true for numbers.

    What other difficulties are you having?

  3. #3
    Join Date
    Apr 2006
    Got it all, thanks !~

Posting Permissions

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