Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Dec 2009
    Location
    Woodbury, GA
    Posts
    15
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by sdckapr View Post
    Have you tried:
    FemaleValue= Range("BG_F").Value

    [img]/S/whisper.gif[/img]Also instead of using the ADD NAMES, it is often easier to just use the range object:
    Range("D" & NextRow + 1).Name:="BG_F"

    Steve
    I've used named range formulas for years with various syntaxes such as the following line from within a With Names grouping.

    .Add Name:="MudInAnnulusVariations", RefersTo:="=offset('Mud Circ Temps'!$B$9,0,9,COUNTA('Mud Circ Temps'!$B:$B)-5)"

    When I attempt to use the shorter syntax as you show in this previous thread here, I get a "Compile Error" "Expected: expression" dialog box. *I've added Activeworkbook, ActiveSheet, Application and nothing eliminates that error.

    I am running Windows 7 Ultimate 64 with Office 2007 Professional with SP2.

    Any clues?

    Mark Trevithick

  2. #2
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Rather than re-opening a 3-year old thread, this post has been cross-referenced and made the subject of a new thread.
    Gre

  3. #3
    WS Lounge VIP
    Join Date
    Dec 2009
    Location
    Earth
    Posts
    8,191
    Thanks
    48
    Thanked 984 Times in 914 Posts
    I don't think Range("BG_F").Value is valid, there is no Value for the entire range. You would need an offset into the range to return a value.
    Please you post the exact code?

    cheers, Paul

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    The simpler method is for "naming a range" (that is giving a name to a formula that is refers to a range).

    You appear to be trying to name a formula that does not refer directly to a range and thus the "Add Name" syntax must be used

    Steve

Posting Permissions

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