View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dana Sherbondy Dana Sherbondy is offline
external usenet poster
 
Posts: 1
Default 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