Previous Topic Next Topic

Determining if a cell value is an integer

Closed
mtbtweety Posts 1 Registration date Tuesday March 3, 2009 Status Member Last seen March 4, 2009 - Mar 4, 2009 at 01:08 PM
 WutUp WutUp - Mar 4, 2009 at 04:15 PM
Hello,
I'm getting type mismatch errors in a Macro, and am trying to resolve it by checking to see if the cell contains an integer, but can't figure out how to do that.

Current line is
If Selection.Cells(i) > 0 Then l = l + 1

I'd like ti to be more like
If (Selection.Cells(i) > 0 AND Selection.Cells(i).type=Integer) Then l = l + 1

but that clearly doesn't work. What's the right language for this?

1 response

Answer 1 / 1
WutUp WutUp
Mar 4, 2009 at 04:15 PM
Maybe you can try an information function with a data type function. Something like.......

If IsNumeric(Val(Selection.Cells(i))) Then
l = l + 1
2

Similar discussions

If a cell contains any text then add a value
cbrizz -
Pharmanumbers -

20 responses
If cell = date return yes or no.
JD -
ndwebb -

5 responses
Formula to Find&replace blank cells in excel
onetuff_z -
tstobb -

11 responses
Excel: If Date =, then enter a value
JerrySD -
BrianGreen -

4 responses
Excel "IF" function w/ date in test cell
Mike in PA -
salim -

6 responses