Get a single sheet name from multiple sheets.

Hi All...
I have 3 different sheets in my workbook, I know the first 2 worksheets names.
Other sheet name will be anything. My need is want to get only the other sheet name.
sheet1.name = "samplesheet1"
sheet2.name = "samplesheet2"
sheet3.name = will be anything

How do I get this via macro?

Hope that make sense.

Here, use this:

Please Login or Register  to view this content.

Thanks for your reply.

I'll give it a try...

Hi zbor,

I tried like this.

Please Login or Register  to view this content.

Thanks for the assistance..

Thank u very much zbor.

I have learned a lot from here.