Don Guillett wrote:
Sub ifallnum()
For Each c In Range("f2:f22")
If Len(c) 0 And IsNumeric(c) Then c.Offset(, -1) = 33
Next


Thanks. I'm guessing (with my small knowledge) this is supposed to put
33 into the column to the right of the selected cell if it IS an
integer. Is this correct? It's not working so far but i'll figure that
out, problem is I need to do it if it is NOT an integer. Can i do a "is
not"?

Oh and what is len?