+ Reply to Thread
Results 1 to 3 of 3

Why is a named range not recognized

  1. #1
    Forum Contributor
    Join Date
    03-30-2010
    Location
    Manchester England
    MS-Off Ver
    Excel 2010
    Posts
    992

    Why is a named range not recognized

    I am using the following code to download some date and then put it into specific columns of another sheet.
    Please Login or Register  to view this content.
    I have been first putting the downloaded data into a variant to speed up the distribution. For a reason I have been unable to discover, the line
    BudgArr = Range("Budget").Value has started to cause an error message "Method Range of object '_Global' failed.
    This is the message that usually I see if I have misspelled a range name. This not the case now though. The range is present in the named range list, and is designated correctly.
    On earlier tests this part of the code worked so I must have changed something, can anyone help?
    John

  2. #2
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Why is a named range not recognized

    Hi,

    Have you tried qualifying the range call with either the sheet that the range is on, or with Application?
    Don
    Please remember to mark your thread 'Solved' when appropriate.

  3. #3
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,059

    Re: Why is a named range not recognized

    Is the sub in a regular module? or is it in one of the sheets? As xlnitwit suggested, specifying the sheet in the reference may help eg. Worksheets("Sheet1").Range("Budget").Value
    Please help by:

    Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
    Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know

    There are 10 kinds of people in this world... those who understand binary, and those who don't.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Dynamic Named Range not recognized in formulas.
    By HuskerBronco in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-21-2019, 09:52 PM
  2. Range Names not recognized by VBA
    By j_Southern in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-17-2017, 05:20 AM
  3. [SOLVED] Compare cells to named range and create new sheets using related named range
    By drewship in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-10-2015, 03:35 PM
  4. IF AND Formula for range created...Why is decimal number not recognized
    By jste123 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-15-2014, 03:46 PM
  5. [SOLVED] Determine what Named Range the Target Address is and return Named Range Name
    By jordan2322 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-18-2012, 10:49 PM
  6. [SOLVED] Convert formula to range name that is recognized by vlookup formua
    By r wilcox in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-12-2006, 11:10 AM
  7. Convert formula to range name that is recognized by vlookup formua
    By r wilcox in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-12-2006, 11:05 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1