If Worksheet name is Number Then...

[TheRobsterUK]

Is it possible to write a macro that looks at every worksheet name and for those that consist of numbers perform some action? The logic would have to look something like:

For every worksheet in workbook
If worksheet name is number then
do stuff
Else
do nothing

Also I'm trying to write code that also counts the number of worksheets that have names that are numbers. I expect this could be made part of the above code, say create a variable that keeps count of how many worksheets have been evaluated as having a number for a name.

Thanks for any help given.

Rob

[Kaper]

for instance:

Please Login or Register  to view this content.

and as a function

Please Login or Register  to view this content.

[patel45]

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.