Visible sheets name to be captured expect two sheets

[rajuganapathy]

Hi All,

i have a VBA code which will capture all the worksheet names in the specified range, so I have attached the excel sheet my question is the only visible sheet names to be captured. below code is working fine.but in that sheet i need to exclude the two visible sheets "Control" and "Summary". I have tried the code

Please Login or Register  to view this content.

but it doesn't work. Looking your assistance.

Please Login or Register  to view this content.

Thanks/Raju

[mehmetcik]

Please Login or Register  to view this content.

[rajuganapathy]

Hi mehmetcik,

I have tried the same but still it's capturing the Control and Summary sheet in the Range("A10"). my concern is both of the sheets are "visible" sheets it shouldn't be captured while running the macro.

Please refer the attached sheet.

Thanks/Raju

[Winon]

Hello rajuganapathy,

If Sheets1 and 2 are always going to be the first two Sheets, "Control" and "Summary" respectively in your Workbook, then you may use this Code below;

Please Login or Register  to view this content.

Regards

[mehmetcik]

Apologies

There was a worse error that I missed. you did not define ws

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[rajuganapathy]

Thank you so much mehmetcik... have a wonderful weekend .....