I have a spreadsheet that allows the user to input mostly numeric values but
once in a while will enter a Text value. I run conditional code to do
something if the numeric value falls into a certain range. I need to check
the format of the cell before I apply the condition to make sure it is
numeric.

How do I check the cells format prior to apply the code. Here is what I
tried but kept getting an object required error

For CellNum = 10 To 22
If (["C" & "CellNum"].NumberFormat) = False Then
GoTo SkipCell
Else...

Thanks for all of your help.

-Chris