subscript out of range message 1

[PavelGur]

I have the following code:
'If Not Windows("SelectCur.xls").Visible Then
If Worksheets("SelectPoliciesCur").Visible = False Then
Workbooks.Open Filename:="c:\Design\SelectCur.xls"
End If
In both cases, commented and uncommented code, I'm getting subscript out of range message.
Thanks in advance, Pav.

 

[rmikesmith]

If you are getting that error with the first line commented out then it means that the worksheet SelectPoliciesCur doesn't exist in the active workbook since

Worksheets("SelectPoliciesCur").Visible

isn't qualified by a specific workbook reference.

Regards,
Mike