Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting different Worksheets from a Loop
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting different Worksheets from a Loop
Does this help?
Sub dosheets() For i = 1 To Worksheets.Count Sheets(i).Select MsgBox ActiveSheet.Name Next i End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "ironhydroxide" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting different Worksheets from a Loop
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--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "ironhydroxide" wrote: 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting different Worksheets from a Loop
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" wrote: Does this help? Sub dosheets() For i = 1 To Worksheets.Count Sheets(i).Select MsgBox ActiveSheet.Name Next i End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "ironhydroxide" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Naming Worksheets - Loop within a loop issue | Excel Programming | |||
Naming Worksheets - Loop within a loop issue | Excel Programming | |||
(Complex) Loop within loop to create worksheets | Excel Programming | |||
selecting columns and a loop | Excel Programming | |||
Selecting columns through a loop | Excel Programming |