VBA to find all sheets name in workbook

[VBA_Leaner]

Hi,

I would like to have macro to find all sheets name in workbook. can anyone guide me?

[Faridwahidi]

Try this,

Please Login or Register  to view this content.

To view printed sheets name, please press CTRL+G in VB Editor

[Greg M]

Hi there,

The following code might help to get you started:

Please Login or Register  to view this content.

Hope this helps - please let me know how you get on.

Regards,

Greg M

[VBA_Leaner]

hi,

both working fine. thanks a lot.

[Greg M]

Hi again,

Many thanks for your prompt feedback - glad I was able to help.

Regards,

Greg M