ExcelBanter - Checking if integer

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

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

- - Checking if integer (https://www.excelbanter.com/excel-programming/311383-re-checking-if-integer.html)

CBrine[_2_]

Checking if integer

Does this help?

If IsNumeric(Range("A1")) Then
MsgBox "yes"
End I

--
CBrin

-----------------------------------------------------------------------
CBrine's Profile: http://www.excelforum.com/member.php...fo&userid=1470
View this thread: http://www.excelforum.com/showthread.php?threadid=26330

All times are GMT +1. The time now is 09:35 AM.