ExcelBanter - Check if sheet name is a number

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Check if sheet name is a number (https://www.excelbanter.com/excel-programming/367049-check-if-sheet-name-number.html)

linglc

Check if sheet name is a number

Does anyone knows of VB to check if the name of the tab is a number?

Tom Ogilvy

Check if sheet name is a number

if isnumeric(activesheet.name) then

--
Regards,
Tom Ogilvy

"linglc" wrote in message
...
Does anyone knows of VB to check if the name of the tab is a number?

All times are GMT +1. The time now is 05:28 PM.