RT Error 1004, Select method of worksheet class failed

[Dana Sherbondy]

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

 

[Bob Flanagan]

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

 

[Guest]

It was marked as hidden. I 'unhide' it and it worked.
Thank you so much!
Dana