That's okay.

Cheers!


"Jacob Skaria" wrote in message
...
Sorry Gerard. I didnt notice the text part..As the other post says you
will
need to use IsNumeric function....Cheers

"Gerard Sanchez" wrote:

This is the code I am working with

If Range ("F65") 0 And _
Range("G59") < "SELECT CUSTOMER" And _
Range("F64") < "SELECT USER" And _
WorksheetFunction.CountA(Range("C61"), _
Range("C62"), Range("F61"), Range("F62"), _
Range("I61"), Range("I62")) = 1 Then

Range("A18:I69").PrintOut Copies:=1

Else

The Problem is that when F65 = "NOT BALANCED !" I don't want it to
print.
Currently it does.

When I replaced first line to this

If CInt("0" & Range("F65")) 0 And _
Range("G59") < "SELECT CUSTOMER" And _
Range("F64") < "SELECT USER" And _
WorksheetFunction.CountA(Range("C61"), _
Range("C62"), Range("F61"), Range("F62"), _
Range("I61"), Range("I62")) = 1 Then

Range("A18:I69").PrintOut Copies:=1

I got a Type Mismatched Error. The whole code is highlighted


"Jacob Skaria" wrote in message
...
Dear Gerard

You can try this. Post back incase of any queries..

If Cint("0" & Range("F65")) 0

If this post helps click Yes
---------------
Jacob Skaria