I want to check if 2 cells equal then go to next step

Here is what I have tried, without any success.

If ActiveCell.Offset(0, -2).Value = ActiveCell.Offset(1, -2).Value Then

TIA
Gerry

Gerry

what do you mean by "without any success" ?  This works fine:

If ActiveCell.Offset(0, -2).Value = ActiveCell.Offset(1, -2).Value Then
    MsgBox "equal"
End If

... with A2 = 2 and A3 = 2 and the Active Cell being C2.  And there's no
message box if the cells aren't equal.

Regards

Trevor

Have you tried with :

If ActiveCell.Offset(0, -2) = ActiveCell.Offset(1, -2) then
or
If ActiveCell.Offset(0, -2).Range("A1") = ActiveCell.Offset(1, -2).Range("A1") then

both should work !
;-) S?ren

Hi Gerry:

The only reason this wouldn't work is if the active cell was in column A or
column B.

Regards,

Vasant.

Perhaps you have your row and column references reversed,  this looks at the
cell in the same row as the active cell and the cell one row after the
active cell and two columns to the left.

So if the active cell were d5  this would compare   b5 and b6

Range("d5").Activate
? activeCell.Offset(0,-2).Address
$B$5
? activeCell.Offset(1,-2).Address
$B$6

Is that what you are trying to do?

Regards,
Tom Ogilvy

Two possibilities:

1.) Maybe you've got rows and columns confused.

2.)  (more likely) in one of the cells, the 'value' is stored as text.

Cheers,

Andrew

Thanks
That worked great!  Maybe the problem I was having is that the cells were
text and not numbers.
Either way it is working now.

Gerry

ActiveCell.Offset(1, -2).Range("A1") then