Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Run-Time error '1004' : Select method of Range class failed | Excel Discussion (Misc queries) | |||
RUNTIME ERROR '1004' --- Select method of worksheet class failed | Excel Programming | |||
excel97: runtime error 1004 select method of range class failed | Excel Programming | |||
error 1004 Select method of Range class failed | Excel Programming |