Results 1 to 7 of 7

Method "Range" of object '_Global' failed

Threaded View

  1. 07-30-2024, 07:26 AM #1
    Gregb11
    Gregb11 is offline
    Forum Expert
    Join Date
    02-10-2019
    Location
    Georgia, USA
    MS-Off Ver
    Office 365
    Posts
    3,270

    Method "Range" of object '_Global' failed

    All of the sudden, I have 2 files that have been working for a long time now fail on this error message:
    Run-time error '1004':
    Method "Range" of object '_Global' failed

    It fails on ranges that are named "StartDate" and "EndDate". If I rename these cells, or create a new range and use the same code, they do not fail. I've attached a file where I have removed all the sheets and deleted everything except the Start and End Dates, and I added another Named Range called "StartDate1". I also removed all the VBA code except to select these cells. It selects the cell named StartDate1 but errors on StartDate.

    Can anybody see why that is?
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Receiving a "Method 'Range' of object'_Global' failed" error
    By aloha31 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-17-2013, 06:51 PM
  2. [SOLVED] "Method 'Range' of object '_Global' failed"
    By vamedic11 in forum Excel General
    Replies: 3
    Last Post: 08-19-2012, 05:54 PM
  3. [SOLVED] method 'Range' of object"_global' failed
    By Stevegia in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-18-2012, 02:09 PM
  4. "The "sheets" method from the "_Global" object have failed."
    By mankit87 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-08-2011, 08:53 AM
  5. Error: "Method 'Range' of object '_Global' failed"
    By dblword in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-26-2009, 05:15 PM
  6. Getting "Method 'Range' of Object '_Global Failed" with Range...Select
    By murpat01 in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 05-14-2007, 03:51 PM
  7. "Method 'Range' of object '_Global' Failed"
    By gnanaprakash in forum Excel General
    Replies: 1
    Last Post: 12-22-2006, 04:03 AM
  8. [SOLVED] Excel-VBA: "1004 - Method 'Range' of object '_Global' failed"
    By THA in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-18-2005, 05:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1