Hi,

I was wondering instead of

If Range("F65") > 0 Then Range so and so .printount

I was wondering if there's any way I can get this line to apply strictly to
numeric results, because currently code sees the text results also as
greater than zero ( >0 ) ??

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

If Isnumeric(Range("F65"))=true and Range("F65") > 0 then blablablablalba

"Gerard Sanchez" wrote:

> Hi,
>
> I was wondering instead of
>
> If Range("F65") > 0 Then Range so and so .printount
>
> I was wondering if there's any way I can get this line to apply strictly to
> numeric results, because currently code sees the text results also as
> greater than zero ( >0 ) ??
>
>
>

Hi Jpcob,

I got a syntax error??


"Jacob Skaria" <(E-Mail Removed)> wrote in message
news:629C9228-92D5-41F9-9950-(E-Mail Removed)...
> 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

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" <(E-Mail Removed)> wrote in message
news:629C9228-92D5-41F9-9950-(E-Mail Removed)...
> 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

This did the trick!

Thanks


"filo666" <(E-Mail Removed)> wrote in message
news:C9D2F502-0AE3-44CD-8948-(E-Mail Removed)...
>
> If Isnumeric(Range("F65"))=true and Range("F65") > 0 then blablablablalba
>
> "Gerard Sanchez" wrote:
>
>> Hi,
>>
>> I was wondering instead of
>>
>> If Range("F65") > 0 Then Range so and so .printount
>>
>> I was wondering if there's any way I can get this line to apply strictly
>> to
>> numeric results, because currently code sees the text results also as
>> greater than zero ( >0 ) ??
>>
>>
>>

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" <(E-Mail Removed)> wrote in message
> news:629C9228-92D5-41F9-9950-(E-Mail Removed)...
> > 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
>
>
>

That's okay.

Cheers!


"Jacob Skaria" <(E-Mail Removed)> wrote in message
news:2BF644FF-079A-41AB-A2DA-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
>> news:629C9228-92D5-41F9-9950-(E-Mail Removed)...
>> > 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
>>
>>
>>

Gerard

Before using isnumeric see this thread.

You could be surprised.

http://tinyurl.com/9to4ka


Gord Dibben MS Excel MVP

On Mon, 16 Mar 2009 00:07:09 -0700, "Gerard Sanchez"
<(E-Mail Removed)> wrote:

>This did the trick!
>
>Thanks
>
>
>"filo666" <(E-Mail Removed)> wrote in message
>news:C9D2F502-0AE3-44CD-8948-(E-Mail Removed)...
>>
>> If Isnumeric(Range("F65"))=true and Range("F65") > 0 then blablablablalba
>>
>> "Gerard Sanchez" wrote:
>>
>>> Hi,
>>>
>>> I was wondering instead of
>>>
>>> If Range("F65") > 0 Then Range so and so .printount
>>>
>>> I was wondering if there's any way I can get this line to apply strictly
>>> to
>>> numeric results, because currently code sees the text results also as
>>> greater than zero ( >0 ) ??
>>>
>>>
>>>
>