Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
list all sheet names between sheet x and sheet y
need list to start in cell A44, in sheet "A".
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
list all sheet names between sheet x and sheet y
Replace the "x" and "y" in the below with the start and end sheet names
For intTemp = Sheets("X").index to Sheets("Y").index Range("A" & 43+intTemp) = Sheets(intTemp).Name Next intTemp If this post helps click Yes --------------- Jacob Skaria "J.W. Aldridge" wrote: need list to start in cell A44, in sheet "A". |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
list all sheet names between sheet x and sheet y
Didnt work.
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
list all sheet names between sheet x and sheet y
The way you set the limits for intTemp, the odds are great that the list
won't start in cell A44 as the OP requested. This way should work... Start = Sheets("X").Index Finish = Sheets("Y").Index For intTemp = Start To Finish Cells(44 + intTemp - Start, "A").Value = Sheets(intTemp).Name Next -- Rick (MVP - Excel) "Jacob Skaria" wrote in message ... Replace the "x" and "y" in the below with the start and end sheet names For intTemp = Sheets("X").index to Sheets("Y").index Range("A" & 43+intTemp) = Sheets(intTemp).Name Next intTemp If this post helps click Yes --------------- Jacob Skaria "J.W. Aldridge" wrote: need list to start in cell A44, in sheet "A". |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
list all sheet names between sheet x and sheet y
If you really expect to get help on a problem you are having, you simply
have to provide useful feedback. "Didn't work" gives us no clue what the problem is (did the code not run, did it run but put the wrong information in the cells, did it make your computer blowup, etc.), so it is kind of hard to figure out what advice to give you next. In the future, don't say "didn't work", tell us what happened that you didn't want to happen. -- Rick (MVP - Excel) "J.W. Aldridge" wrote in message ... Didnt work. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
list all sheet names between sheet x and sheet y
For intTemp = Sheets("X").index to Sheets("Y").index
Sheets("A").Range("A" & 43+intTemp) = Sheets(intTemp).Name Next intTemp If this post helps click Yes --------------- Jacob Skaria "J.W. Aldridge" wrote: Didnt work. |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
list all sheet names between sheet x and sheet y
Thanx Mr. Jacob!
Worked purfetly! Noted Mr. Rick (I kinda thought since it seemed so simple no additional info was needed) Thanx anyhow. |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
list all sheet names between sheet x and sheet y
Cheers..
If this post helps click Yes --------------- Jacob Skaria "J.W. Aldridge" wrote: Thanx Mr. Jacob! Worked purfetly! Noted Mr. Rick (I kinda thought since it seemed so simple no additional info was needed) Thanx anyhow. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sheet Referencing - autofilling sheet names | Excel Worksheet Functions | |||
hyperlink to sheet name where sheet names=cell content | Excel Programming | |||
Generate sheet names from list, assign data to summary sheet. | Excel Programming | |||
List sheet names | Excel Programming | |||
Inserting a row in sheet A should Insert a row in sheet B, removing a row in Sheet A should remove the corresponding row in sheet B | Excel Programming |