+ Reply to Thread
Results 1 to 4 of 4

Method 'Range' of object' _Worksheet' failed

  1. #1
    Registered User
    Join Date
    06-12-2012
    Location
    Wichita, Kansas
    MS-Off Ver
    Excel 2010, 2016, 2021-22
    Posts
    87

    Method 'Range' of object' _Worksheet' failed

    I'm getting this error when hitting the button called "Create Specification List". It was working for weeks and now it's giving me this error. I will upload an example of the sheet I'm working on.

    Any help would be greatly appreciated!!
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    06-12-2012
    Location
    Wichita, Kansas
    MS-Off Ver
    Excel 2010, 2016, 2021-22
    Posts
    87

    Re: Method 'Range' of object' _Worksheet' failed

    I figured it out, I inserted a column in place of another and I didn't turn it back into a range.

  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: Method 'Range' of object' _Worksheet' failed

    2 of your named ranges seem to have issues... that's probably why. In the Formulas tab, go to Name manager and see if fixing the ranges solves the problem.
    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.

  4. #4
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    Re: Method 'Range' of object' _Worksheet' failed

    That cannot have worked, you're combining (Union) of more than one range.
    You assign a variable and you set with Union(....) then it might work
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

+ 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] Method 'Range' of object'_Worksheet' failed
    By danfullwood in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-03-2016, 12:33 PM
  2. Method 'Range' of Object'_Worksheet' Failed
    By himabinduk in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-17-2014, 07:24 AM
  3. Method 'Range' of object '_Worksheet' failed
    By vbachallenged in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-17-2012, 02:56 PM
  4. [SOLVED] Method 'Range' of object '_Worksheet' failed
    By Burli in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-24-2012, 05:46 AM
  5. Method 'Range' of object '_Worksheet' failed
    By Kaigi in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-07-2012, 11:06 AM
  6. Method 'Range' of object '_worksheet' failed
    By wilro85 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-06-2010, 06:24 PM
  7. Method 'Range' of object '_Worksheet' failed
    By JSnow in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-27-2009, 03:55 PM

Tags for this Thread

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