expected end of statement error while using IF

[akkinarula]

HI All,

I m getting expected end of statement while using following

ActiveCell.FormulaR1C1 = _
"=IF('Customer''s Details'!R" & Trim(Str(a)) & "C21" "=" ""Yes"",""Dispensor"","" "")"

where i m checking the condition with my Customer's Details sheets row whose no is 'a' which i initialize to 13 and it will increment by loop.
And i m using MS excel 2003

plz help me if anyone knows the answere

 

[Richard Schollar]

Try writing it as:

ActiveCell.FormulaR1C1 = _
"=IF('Customer''s Details'!R" & Trim(Str(a)) & "C21=""Yes"",""Dispensor"","" "")"

 

[akkinarula]

Try writing it as:

ActiveCell.FormulaR1C1 = _
"=IF('Customer''s Details'!R" & Trim(Str(a)) & "C21=""Yes"",""Dispensor"","" "")"

problem is solved.
thank u very much.