If condition

[RSEKAR]

Dear Sir,

I use Excel 2002
I am unable to use IF condition to run a macro between two books
If the numerical data between the particular cells of the two books is not equal then the macro should run.
I have 2 excel books TUMA.XLS AND SEKAR.XLS
In both books I have a sheet by name “ALL”
I want to create a condition as in both the cells (AR10) of both the “ALL” sheets if found not equal the macro should run.
If the cells are equal the macro should not run.
I have tried the following line in the beginning of the macro.
I get error message on completing the line.
Kindly advice how to give the IF condition to start the macro.
IF [TUMA.xls] (ALL!$AR$10) <> [SEKAR.xls]ALL!$AR$10) Then
Call (macro name)
Macro is present in the TUMA.XLS book.
Thanking you Sir,

 

[VoG]

Maybe

If Workbooks("TUMA.xls").Sheets("ALL").Range("AR10").Value <> Workbooks("SEKAR.xls").Sheets("AL").Range("AR10").Value Then

 

[RSEKAR]

Dear Sir,
Very simple and it is working very well
Thanking you,

 

[RSEKAR]

Dear Sir,
How to add OR with the above statement.
If
AR10<>AR10 OR
AR11<>AR11 OR
AR12<>AR12 Then
Call Macro
(if any one or more conditions become true the macro should start).

Thanking you,

 

[RSEKAR]

Dear Sir,
I got the answer to use OR with the above statements.
Thanking you for your statement above which I further built up.