Using excel vba to create an if formula with variable columns

[adles]

Hi

i am trying to write a macro that will sort two columns. In order to so I must compare cell a10 with cell e10 (this cell might be another column depending on width of first column). So, i need the formula to be able to reflect what the cell reference is. I have in cell c3 what this should be so in this example it is the letter e

I have tried ActiveCell.FormulaR1C1 = "=IF(RC[-8]=RC[-4],""OK"",""problem"")" but when i put a variable (that I know) instead of the 8 or 4 it wont work/

Any help appreciated

[JLGWhiz]

You could do it without using a formula

Please Login or Register  to view this content.

[adles]

Wow, excellent. Thanks so much. It had never occurred to me to use a loop. I have waster so much time and your solution is so elegant

Once again, thanks

[JLGWhiz]

Wow, excellent. Thanks so much. It had never occurred to me to use a loop. I have waster so much time and your solution is so elegant

Once again, thanks

You are welcome,
regards, JLG