*see attached file*
On Wed, Sep 2, 2009 at 1:37 PM, ymusafi wrote:
>
> Hi All
> I want to create a macro that is doing somthing if the cell value has
> non numeric value
> meaning:
> if cell.value=???then
> I just need to know what to put instead of the question marks
> Thanks!
>
> >
>
--
Th
ymusafi,
The following code checks to see whether the cell's contents is
numeric or not:
Public Function Test(cell As Range)
If IsNumeric(cell.Value) Then
Debug.Print "Numeric"
Else
Debug.Print "Not numeric"
End If
End Function
Try it in the Immediate Window by typin
