If statement in VBA

J

Jeff

Hello,

I need help designing a VBA Macro to execute the following:

IF (A2=A1,0,1)
I need to execute this VBA macro from 1 to 300.
Thanks,
 
R

Ron de Bruin

Try this for the active sheet
It will use the B column to display the 0 or 1

Sub test()
Dim a As Long
For a = 2 To 300
If Cells(a, 1).Value = Cells(a - 1, 1).Value Then
Cells(a, 2).Value = 0
Else
Cells(a, 2).Value = 1
End If
Next a
End Sub
 
Top