Vba if statement help

[bloodmilksky]

Hi Guys,

I am just experimenting and trying to learn VBA. I was just wondering if anyone knew the VBA Code for:

IF Range "A" Exceeds "X" Value Then Move To Sheet A

Thank you.

 

[Joe4]

Do you mean something like this:

If Range("A1") > X Then Sheets("Sheet A").Select

where X is some value, i.e. maybe
X=10
or
X=Range("B1").Value
is set somewhere earlier in the code.

 

[Special-K99]

...or do you mean

If Range("A1") > Range("X1") Then Sheets("Sheet A").Select

 

[bloodmilksky]

Thank you ^_^

 

[bloodmilksky]

So I mean if cells A1:A3 exceed a value of 12 then move to Sheet A.

 

[Joe4]

So I mean if cells A1:A3 exceed a value of 12 then move to Sheet A.

Do all three need to exceed 12, or just one of them?

 

[bloodmilksky]

the total amount of all 3 exceed 12 then move onto a different sheet.

 

[Joe4]

Try:

If Application.Sum(Range("A1:A3")) > 12 Then Sheets("Sheet A").Select