Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

"Use in Formula" feature for a named range in 2007

Latest post Fri, Feb 29 2008 11:12 AM by Nick Hodge. 1 replies.
  • Fri, Feb 29 2008 7:24 AM

    "Use in Formula" feature for a named range in 2007

    Very nice to see this as a "button", however you do not seem to be able to access it to use in from within a dialog box.  e.g. within the function arguments box for vlookup I would have used Insert menu, Name, paste....  Does anybody know if this is a reported problem which is being fixed?

    • Post Points: 21
  • Fri, Feb 29 2008 11:12 AM In reply to

    • Nick Hodge
    • Top 10 Contributor
    • Joined on Sun, Dec 23 2007
    • Southampton
    • Posts 336
    • Points 5,771
    • MVP

    Re: "Use in Formula" feature for a named range in 2007

    Angela

     I've not used this before but it works for me. I defined a named range and then activated the 'Insert Function' funcionality from the formulas tab. That fires up a wizard with the various parameters needed for a VLOOKUP and if I click in a refedit box (The ones you can select cells from), I can still access the 'Use in Formula' button which inserts my named range as the argument.

    Am I missing something?

    Regards
    Nick Hodge
    Microsoft MVP, Excel
    Southampton, UK

    Filed under: ,
    • Post Points: 5
Page 1 of 1 (2 items) | RSS
Copyright Excel User Group and the relevant contributors, 2008. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.