Thread: Detecting Double Entries

I'd like to use an "IF" statement for a macro, but I dont' know how to
describe the condition to VBA. Basically, the condition is whether or not two
cells have the same value in column K. Thanks

comparini3000

Assuming rows 1 and 2
If Cells(1, 11).Value = Cells(2, 11).Value then

or

If Range("K1").Value = Range("K2").Value then

You don't really have to use the .Value part

"comparini3000" wrote:

> I'd like to use an "IF" statement for a macro, but I dont' know how to
> describe the condition to VBA. Basically, the condition is whether or not two
> cells have the same value in column K. Thanks
>
> comparini3000