Here's a macro that lists sheet names!

[ninj5]

I found a macro that will list all the sheets in a workbook.
Just replace the two "MasterSheet" with the sheet name you want the data in.
(it will erase that sheet and list all the sheets in your workbook.


Can anyone adjust this macro so it only lists the sheets with tab color red?




Macro:

Please Login or Register  to view this content.

[HSV]

Hello ninj5,

Try it once.

Please Login or Register  to view this content.

[arlu1201]

ninj5,

Welcome to the forum.

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature below this post.