Object usage versus using a numerical variable in .find function

Hello,

Thank you for your help in advance.
I've got two things I'm specifically looking for help on, and also appreciate any recommendations.

1. I'm having trouble getting the .find function working below - which is bold and underlined

2. I'm wondering if the 'IF' statment below the .find function (underlined) should be written as MatchRow.offset(x,x).value = [xx]

Definitely open for recommendations, as I feel there is a better way to achieve the objective; the objective is to find rows with "UE" and no color (-4142), then use the dollar amounts to see if there are any offsetting amounts in the same data set with a few differences ("AB", etc). If found, then highlight both values pink (26).

ScreenShot.JPG

Please Login or Register  to view this content.

Thank you much!