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