VBA error on a hidden sheet

[e.cichlid]

Hello,

I've done a search here and could not find the same situation as me.

I have a pull-down menu on worksheet_2 that has a macro assigned. The macro looks on worksheet_1 for the data and plots a graph on worksheet_2. If I hide worksheet_1 the macro stops at a marker directing to look on worksheet_1.

Is there a work around for this?

Thanks.

 

[VoG]

Can you post the code. You can't select a hidden sheet but you can read data from it.

 

[e.cichlid]

Below is the code.

Sub Macro1()
'
' Macro1 Macro
'
'
Select Case Range("A1").Value
Case 1

Sheets("Worksheet").Select
Range("BT3:CD3").Select
Selection.Copy
Sheets("Sheet1").Select
Range("C1").Select
ActiveSheet.Paste

Case 2

Sheets("Worksheet").Select
Range("BT4:CD4").Select
Selection.Copy
Sheets("Sheet1").Select
Range("C1").Select
ActiveSheet.Paste

etc.... 40 cases

End Select
End Sub

 

[VoG]

Try this for Case 1

Case 1

Sheets("Worksheet").Range("BT3:CD3").Copy Destination:=Sheets("Sheet1").Range("C1")

Case 2