Macro Target Cell

[kmlloyd]

I found this macro online and it does what I need it to do....except I want it to list the sheet names start in cell A11. How do I fix that?

Please Login or Register  to view this content.

[Ron Coderre]

Try this:

Please Login or Register  to view this content.

Is that something you can work with?

[xladept]

Hi km,

This will list them on the ActiveSheet, omitting the ActiveSheet name:

Please Login or Register  to view this content.

[Andrew1983PL]

Hello,

Sub list_of_sheets_name()
k=10
for each sh in thisworkbook.sheets
k=k+1
Range("A" & k) = sh.name
next sh
End Sub

[kmlloyd]

Thank you thank you! Is there any way to have it list only the worksheets between certain names? For example...here is my list of WS....What I'm really aiming for is a list of customers...everytime someone sends me a new order, I copy my Template worksheet to a new sheet and rename it with the customer's name.

I'd like to then go into the "Summary" WS (not shown) and update the list of customers....this WS then pulls data I need for reporting.

So I really don't need these ones to show:
1. Item List
2. Shipping and Tax
4. Template
AAAAA
ZZZZZ
Sheet36


Hopefully this makes sense.

This is the list of all of my worksheets, aside from the Summary Sheet that this list will go into.
1. Item List
2. Shipping and Tax
4. Template
AAAAA
Customer Name 1
Customer Name 2
Customer Name 3
Customer Name 4
Customer Name 5
Customer Name 6
Customer Name 7
Customer Name 8
Customer Name 9
Customer Name 10
ZZZZZ
Sheet36

[xladept]

Maybe:

Please Login or Register  to view this content.

[kmlloyd]

That worked! Thank you so much!

[xladept]

You're welcome and thanks for the rep!

[xladept]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.