Compile Error: Expected expression

[drewship]

Hello all.
Trying to compare values between cells in row 1 with offset cells in row 3 and get a 'Compile Error: Expected expression' on the colored line. I tried various combinations of () with various errors. How should this be written? Thanks.

Please Login or Register  to view this content.

[AB33]

Please Login or Register  to view this content.

[drewship]

Thanks AB33. I copied the code block but now I get Run-Time error 13: Type mismatch on the colored line below. Both MyCell and cellOffset are ranges so I am confused. If cell "D1" is being compared to cell "D3", the offset(2) should do this. The only thing I can think of is that "D1:F1" calculated values based on a "CountIf" formula. Wouldn't .Value get the actual value of the cell?

Please Login or Register  to view this content.

[AB33]

I knew the code was wrong.

Set cellOffset = All_Data.Offset(2

is a range, so you can not compare(Evaluate) it against a range, but you can against a single cell

If MyCell.Value < cellOffset.Value Then

You can use this line

Please Login or Register  to view this content.

' this is going down

OR

Please Login or Register  to view this content.

[drewship]

PERFECT!!!!!!! I know enough to understand what I am trying to do logically but it is the details that get me every time.

[drewship]

Tried to add rep but won't let me until I spread some more around...