Set cell value by using .Offset and .Find

[mmogharreban]

I am trying to set a cell value = to "X" by finding one cell value (= to value in cell D7 on sheet1) on another sheet (= to value in cell B7 on sheet1) and entering the "X" two columns to the left of the found value. I am using the code below. Can anyone advise what I am doing wrong here?

Thanks

Mike

Please Login or Register  to view this content.

[p24leclerc]

try the following macro:

Please Login or Register  to view this content.

[mmogharreban]

Many thanks Pierre. Unfortunately I am still not getting the desired result. The Macro is running with no error message, just not making the change...
Here is what I am using

Please Login or Register  to view this content.

[mmogharreban]

I stand corrected...this works beautifully! Thanks Pierre!