ExcelBanter - Check if sheet's name is a number

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Check if sheet's name is a number (https://www.excelbanter.com/excel-discussion-misc-queries/98993-check-if-sheets-name-number.html)

linglc

Check if sheet's name is a number

Can someone help with VB to test if a tab's name is a number? Thanks for any
help.

JMB

Check if sheet's name is a number

IsNumeric(Sheets(1).Name)

"linglc" wrote:

Can someone help with VB to test if a tab's name is a number? Thanks for any
help.

All times are GMT +1. The time now is 01:16 PM.