I need to find the format type of a cell in excel. I have an IF statement
that will take a numeric number and apply it to a range to see if it falls
into the range or outside of the range but when the cell has a text value it
bombs on me.

I need to validate which format it has before I apply the condition.

Thanks for you help,

-Chris

How about:
If IsNumeric(cell.value) Then
rather than putzing with cell formatting?

--
George Nicholson

Remove 'Junk' from return address.


"Chris" wrote in message
...
I need to find the format type of a cell in excel. I have an IF statement
that will take a numeric number and apply it to a range to see if it falls
into the range or outside of the range but when the cell has a text value
it
bombs on me.

I need to validate which format it has before I apply the condition.

Thanks for you help,

-Chris

Chris

If isnumeric then
your If statement
else
end if (if you want to do nothing if it is text)


"Chris" wrote:

I need to find the format type of a cell in excel. I have an IF statement
that will take a numeric number and apply it to a range to see if it falls
into the range or outside of the range but when the cell has a text value it
bombs on me.

I need to validate which format it has before I apply the condition.

Thanks for you help,

-Chris