Sub test()
Dim i
For i = 1 To 100
Cells(i, 1) = VBA.Oct(i)
Cells(i, 2) = Val(Int(i / 8) & i Mod 8)
Cells(i, 3) = Cells(i, 1) = Cells(i, 2)
Next
End Sub
Sub test()
Dim i
For i = 1 To 100
Cells(i, 1) = VBA.Oct(i)
Cells(i, 2) = Val(Int(i / 8) & i Mod 8)
Cells(i, 3) = Cells(i, 1) = Cells(i, 2)
Next
End Sub