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?
Configuration: Windows XP Internet Explorer 6.0
Calculate if cell contain values Cell address based on cell value Excel conditional format highlight only if cell value exists Excel convert cell value to integer Excel if cell is specific number of characters then count Excel return value if cell formatted Excel vba code check cell value Formula for exacting a cell value If cell = no If cell a1is color then cell a2 color If cell has more than one word xls If cell is in yellow it say h If condition is true write the true cell value in excel If max display cell value in another row formula excel If the given condition is true how to write the true cell value in excel Vba autofill if cell has value Vba find cell value in column and return text in adjacen cell Vba set cell value multiple sheets