Selecting different Worksheets from a Loop

[ironhydroxide]

I am trying to select worksheets within a Loop function where the worksheet
changes every time. I thought one could use a String in place of the
Worksheets("worksheet name")
But apparently i am wrong because i get a Run-time error '9' Subscript out
of range (which i think means, there is no worksheet with that name)

Thanks for any and all replies

Ironhydroxide

 

[Don Guillett]

Does this help?

Sub dosheets()
For i = 1 To Worksheets.Count
Sheets(i).Select
MsgBox ActiveSheet.Name
Next i
End Sub

 

[ryguy7272]

Post your code, or try this:
http://www.rondebruin.nl/copy2.htm

You need something like this...
For Each sh In ActiveWorkbook.Worksheets


Next

HTH,
Ryan---

 

[ironhydroxide]

Thanks. i realized that i was using worksheets and not sheets (i ran into
this same problem not 6 months ago, but then i stopped using excel and didnt
have to program, so i lost it.

Thanks.

 

[Don Guillett]

glad to help