Simple Code Question

[keithb]

How do you write a simple "IF A = B Then" to place in an Excel code?
keithb

 

[Michael M]

An example would be

If range("A1").value= Range("B1").value then

or if you were doing IF /Then over a lot of rows you could use

dim r as long
for r = 1 to 100 ' sample no of rows
If range("A" & r).value= Range("B" & r).value then
next r

 

[Michael M]

duplicate post deleted

 

[keithb]

Thank you Michael M, that is what I needed

Keithb

 

[Peter_SSs]

The VBA built-in Help has more information about various syntax forms for If...Then as well as examples. Might be worth taking a look at that.