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
.