Tag Archives: IsNumeric

Check if cell is a number

This quick piece of code will run down the current sheet and if the value in the cell is NOT a number or is BLANK it will give you a messagebox of what the value is. This is useful for when you want to determine if a particular cell has a number, and if not […]

Check if the first character in a cell is a number

Address and Location analysis often requires the identification of the value in a cell starting with a number (ie house number) or not a number (in the case of a Flat or named house/building for instance). Using the IsNumeric or Not IsNumeric functions of VBA can help you achieve the analysis of a huge set […]

the webdesigner group security shielf
the webdesigner group logo

Close Button

Web Page Design by

The Web Designer Group