• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Recent content by NukeRiskGuy

  1. N

    INDIRECT with local named range

    Luke, I like your idea about using formulas to feed the INDEX function without using INDIRECT. I will play around with it some more today and let you know tomorrow what I figured out. Thanks for your prompt response to my question! NukeRiskGuy P.S. I would still like to understand why...
  2. N

    INDIRECT with local named range

    I have over 70 point names in Row 2 of a calculation worksheet: T6112 T6113 ... T6115 In another worksheet (named "data"), I have the data from each of these points and have created dynamic named ranges in VBA for each point - these dynamic named ranges are in the form of p_[point name]...
  3. N

    INDIRECT with local named range

    STATOR COIL WATER TEMP T6115@UNIT 148.50497 147.82567 147.4859 148.17952 148.16534 148.84451 148.51912 148.53325 Note that my OFFSET begins with the third row which is the 148.50497 value.
  4. N

    INDIRECT with local named range

    In Excel 2003, how come this works: =INDEX(data!p_T6115,1,1) but in a different worksheet, this does not work: =INDEX(INDIRECT("data!p_T6115"),1,1) The defined name p_T6115 refers to: =OFFSET(data!$AK$3,0,0,COUNTA(data!$AK:$AK)-2,1) and I have tried it with p_T6115 defines as local and...
  5. N

    Select Case with multiple ranges

    One trick that I use with Select Case statements is to use "Select Case True" (see below). This allows you to sequentially process logic statements (similar to nested IF-THEN-ELSE statements, but with more flexibility and better readability). Select Case True Case logic1 ' do something Case...
See more
Back
Top