RT Error 1004, Select method of worksheet class failed
I am receiving an error: "Run Time Error 1004 Select
method of worksheet class failed" on the following section of code: Sheets("Forecasts").Select Cells.Select Selection.Sort Key1:=Range("Q2"), Order1:=xlAscending, _ Header:=xlGuess, OrderCustom:=1, MatchCase:= _ False, Orientation:=xlTopToBottom Sheets("UpdatePeriod").Select <---- ERROR ON THIS LINE Period = Range("a6").Value This macro seemed to work fine until I added a form to the spreadsheet. Is the form causing issues related to the class I'm using? TIA. Dana |
RT Error 1004, Select method of worksheet class failed
Its more likely that you renamed the sheet "UpdatePeriod" or are now
spelling it with a space or that sheet doesn't exist. Robert Flanagan Macro Systems Delaware, U.S. 302-234-9857 http://www.add-ins.com Productivity add-ins and downloadable books on VB macros for Excel "Dana Sherbondy" wrote in message ... I am receiving an error: "Run Time Error 1004 Select method of worksheet class failed" on the following section of code: Sheets("Forecasts").Select Cells.Select Selection.Sort Key1:=Range("Q2"), Order1:=xlAscending, _ Header:=xlGuess, OrderCustom:=1, MatchCase:= _ False, Orientation:=xlTopToBottom Sheets("UpdatePeriod").Select <---- ERROR ON THIS LINE Period = Range("a6").Value This macro seemed to work fine until I added a form to the spreadsheet. Is the form causing issues related to the class I'm using? TIA. Dana |
RT Error 1004, Select method of worksheet class failed
It was marked as hidden. I 'unhide' it and it worked.
Thank you so much! Dana -----Original Message----- Its more likely that you renamed the sheet "UpdatePeriod" or are now spelling it with a space or that sheet doesn't exist. Robert Flanagan Macro Systems Delaware, U.S. 302-234-9857 http://www.add-ins.com Productivity add-ins and downloadable books on VB macros for Excel "Dana Sherbondy" wrote in message ... I am receiving an error: "Run Time Error 1004 Select method of worksheet class failed" on the following section of code: Sheets("Forecasts").Select Cells.Select Selection.Sort Key1:=Range("Q2"), Order1:=xlAscending, _ Header:=xlGuess, OrderCustom:=1, MatchCase:= _ False, Orientation:=xlTopToBottom Sheets("UpdatePeriod").Select <---- ERROR ON THIS LINE Period = Range("a6").Value This macro seemed to work fine until I added a form to the spreadsheet. Is the form causing issues related to the class I'm using? TIA. Dana . |
All times are GMT +1. The time now is 02:36 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com