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
|