List All Worksheet Names BETWEEN Two Worksheets

[dpaik09]

Hi All,

First post here and would appreciate your help. I'm trying to list all worksheet names in between two worksheets named: "front" and "back" on a single sheet named "Client Summary."

Currently, my code looks like the below which lists ALL sheets and I have to manually typeAnd Sh.Name <> "New Sheet Name" in the VBA code to exclude certain sheets. I would like to exclude ALL sheets except those sheets in between the sheet "front" and "back."

Please Login or Register  to view this content.

Thank you all in advance.

Daniel

[mikerickson]

Try this

Please Login or Register  to view this content.

[dpaik09]

Thanks Mike!!

Sorry, I forgot to add, how do you have the list start on row 3? I cannot figure it out for the life of me... Thanks again.

[stnkynts]

Try this amendment to Mike's code

Please Login or Register  to view this content.