Results 1 to 2 of 2

Get Select Method of Range Class failed in macro spreadsheet - 2013

Threaded View

  1. #1
    Registered User
    Join Date
    06-11-2010
    Location
    Windsor, Canada
    MS-Off Ver
    Excel 2007
    Posts
    55

    Question Get Select Method of Range Class failed in macro spreadsheet - 2013

    Attached spreadsheet works fine in 2010 with the Microsoft fix for Dec 9 Microsoft bug. But in Excel 2013 when I try and add an Invoice it takes a long time to update then it fails.

    See performance issues. Do an unprotect and unprotect of all the worksheets which now seems to be a problem.

    Taking a long time for my combo box for Cost Center to come back with values. Vendor combo box works quickly.

    Get a runtime error of 1004: Select Method of Range Class failed.

    Happens on this line of code in method Clear_Invoice

    Range("Invoice_Date").Select
    Data actually gets updated but in Office 2013 I end up with two blank inserted sheets. This does not happen in 2010.

    How do I fix the problem.

    In 2013 go to Invoices Worksheet then key in Invoice# (make up a number - is alpha numeric),, Vendor#, Cost Center#, Total Invoice Amount, Select Object/Sub account, tab to amount column then key in amount, tab out of Amount column then press the SAVE button. You will get the runtime error and the macro will move you to a blank worksheet. In fact is shows two blank worksheets. In Office 2010 and before the Macro Saved the data, Cleared the Invoices worksheet, reset the Invoice Date, then put the client in the Invoice# cell. The Invoice previously saved shows in the upper portion of the spreadsheet.

    Is almost like the spreadsheet looses where it is even though my cells are defined names. This was not happening in Excel 2010 or any version prior.

    Did a google search which indicated that protecting and unprotecting worksheet VBA logic causes issues. Also, it may have lost the cell you were selecting if you are deleting multiple rows and doing all kinds of formatting. See links below. Has anyone come across these issues and how do I fix them.

    https://support.office.microsoft.com...rs=en-CA&ad=CA

    http://support.microsoft.com/kb/244435 *** how to reset last cell in Excel ***
    Attached Files Attached Files
    Last edited by cmwilbur; 02-05-2015 at 03:16 PM.
    cmwilbur

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Help with Auto Filter in Excel 2013 - Autofilter method of Range class failed
    By yus786 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-21-2014, 03:25 PM
  2. Macro debugging (2): Select method of range class failed
    By VelvetRevolver84 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-23-2013, 10:21 PM
  3. Select Method of range class failed
    By excel_rookie74 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-27-2006, 12:17 PM
  4. Select method of Range class failed
    By Capo in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-09-2006, 11:27 AM
  5. What did I do? (Select Method of Range Class Failed )
    By HotRod in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-20-2005, 10: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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1