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

Detecting Double Entries
 

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