Do not include specific multiple worksheets in a VBA programed list

Hi,

I have the below code that lists the worksheets name in column A of my active sheet which is greater and less than sheet2.

Please Login or Register  to view this content.

What I am trying to do is have multiple declared sheets not to be part of this list and I have no idea how and where to put it.

For example:

If wSheet.Name ="Sheet1","Sheet3", "Summary", "Sheet5" - Don't Include but anything else include in the list.

Any help would be greatly appreciated.

How about

Please Login or Register  to view this content.

Fluff13, it works perfectly. Thank you very much

Glad to help & thanks for the feedback

Sorry, If I want the VBA list to start lets just say from range ("B8") on Summary sheet how would I put that in the code.

Try

Please Login or Register  to view this content.

Again, thanks again Fluff. Tried to rep you again but I was told to share the love

Glad to help & thanks for the feedback