Hi all, i am trying to understand what the following macro does without running it.
If someone has knowledge on this and can explain to me in detail what it does and how you know it performs this function (without running it)
it would be much appreciated. I am just trying to learn more on visual basic and I am quite a noob.
Thank you very much.
Sub hello()
Dim FirstInteger As Integer
FirstInteger = 2
For i = 2 To 100000
Cells(1, 2) = Cells(i, 1)
Cells(1, 3) = "=vlookup(B1,D2:D100000,1,0)"
If IsError(Range("c1")) = True Then
Cells(FirstInteger, 4) = Range("B1")
FirstInteger = FirstInteger + 1
End If
If Cells(i + 1, 1) = "" Then
i = 200000
End If
Next i
Range("B1:C1").ClearContents
End Sub
If someone has knowledge on this and can explain to me in detail what it does and how you know it performs this function (without running it)
it would be much appreciated. I am just trying to learn more on visual basic and I am quite a noob.
Thank you very much.
Sub hello()
Dim FirstInteger As Integer
FirstInteger = 2
For i = 2 To 100000
Cells(1, 2) = Cells(i, 1)
Cells(1, 3) = "=vlookup(B1,D2:D100000,1,0)"
If IsError(Range("c1")) = True Then
Cells(FirstInteger, 4) = Range("B1")
FirstInteger = FirstInteger + 1
End If
If Cells(i + 1, 1) = "" Then
i = 200000
End If
Next i
Range("B1:C1").ClearContents
End Sub