how to find the first worksheet with the year as name

[glda19]

Hi
I have many worksheet in an woorkbook. Like printkalender and onder with 2018 2019.
Now i whant to now what is the name of the first sheet with only a year in the name tab

[Mumps1]

Try:

Please Login or Register  to view this content.

[glda19]

thx
But how can i find a random sheet with is mumeric

[Mumps1]

In your original post, you said:

the name of the first sheet with only a year

so the macro I suggested finds the first sheet. What do you mean by

find a random sheet

[glda19]

How can i find eny sheets that have only mumbers like 2020 2018 2019
No not only the first sheet with in the name only mumbers but also sheets with a specific number

[bakerman2]

How about this.

Please Login or Register  to view this content.

[Mumps1]

Do you want to search for a specific sheet or for the first sheet? If you want a specific sheet, what is the specific number or do you want to be prompted to enter the number you want to search?

[glda19]

@bakerman2
What is the use of that like "[2-9][0-9][0-9][0-9]"

[glda19]

i what both first and a specific sheet
for exmaple 2019 or any other number

[Mumps1]

How do you determine which sheet is the specific sheet? When the first sheet and specific sheet are found, what do you want to do with them?

[glda19]

i want to find any sheet that have only numbers

[Mumps1]

Try:

Please Login or Register  to view this content.