J
jfcby
Hi,
Why does the script below give me the "subscript out of rage error"
when tring to select a worksheet?
Sub ActvateWorksheet()
'Activate worksheet
Worksheets("Sheet8").Activate
End Sub
In the help file I found:
"The following example uses the Activate method to activate Sheet1"
Sub ActvateWorksheet()
Worksheets("Sheet1").Activate
End Sub
But, when I run the macro it gives me the above error.
Thank you for your help,
jfcby
Why does the script below give me the "subscript out of rage error"
when tring to select a worksheet?
Sub ActvateWorksheet()
'Activate worksheet
Worksheets("Sheet8").Activate
End Sub
In the help file I found:
"The following example uses the Activate method to activate Sheet1"
Sub ActvateWorksheet()
Worksheets("Sheet1").Activate
End Sub
But, when I run the macro it gives me the above error.
Thank you for your help,
jfcby