Having Problems Activating a Worksheet

[tudor30]

Debugging... I've tried the following combinations WITHOUT success to Activate a named sheet from ECN Navigator.xls

Workbooks(strECNN & "D0_Face.xls&quot.Activate
Set f = ActiveSheet
Workbooks("ECN Navigator.xls&quot.Activate
Worksheets("ECN Face Page&quot.Activate
Set t = ActiveSheet
(Produces Run Time Error 9 - Subscript out of range and highlights the last line, ie Worksheets("ECN....

Next attempt:
Workbooks(strECNN & "D0_Face.xls&quot.Activate
Set f = ActiveSheet
Workbooks("ECN Navigator.xls&quot.Sheets("ECN Face Page&quot.Activate
Set t = ActiveSheet
Same Error Message as Above

any suggestions?
John

 

[SkipVought]

hi,

Worksheets("ECN Face Page.xls&quot.Activate

BUT...

why all this activating and selecting??? Don't need to do that nor should it be done in most cases.

faq707-4105 How Can I Make My Code Run Faster?



Skip,

http://www.TheOfficeExperts.com

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[SkipVought]

OOPS. it was a worksheet, wasn't it.

Are you sure the worksheet name is correct? Probably is NOT!

Set f = Workbooks(strECNN & "D0_Face.xls").ActiveSheet 
Set t = Workbooks("ECN Navigator.xls").
Worksheets("ECN Face Page")


Set f = Nothing
Set t = Nothing

Personally, I try NOT to use spaces in folders and file names

Skip,

http://www.TheOfficeExperts.com

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884