Previous Topic Next Topic

Determining if a cell value is an integer

Closed
mtbtweety Posts 1 Registration date Tuesday 3 March 2009 Status Member Last seen 4 March 2009 - 4 Mar 2009 à 13:08
 WutUp WutUp - 4 Mar 2009 à 16:15
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

Réponse 1 / 1
WutUp WutUp
4 Mar 2009 à 16:15
Maybe you can try an information function with a data type function. Something like.......

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

Similar discussions

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

20 responses
Clear cell contents based on value of another cell range using VBA
Tbonekiller -
Tbonekiller -

6 responses
help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
Excel - IF function with multiple words
Nick -
user -

14 responses