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
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 ***
LinkBack URL
About LinkBacks
Get Select Method of Range Class failed in macro spreadsheet - 2013
Register To Reply
Bookmarks