ivandgreat
Registered User.
- Local time
- Today, 15:45
- Joined
- Sep 18, 2012
- Messages
- 30
Hello,
I have the excel vba in my data and i wanted to convert the vba code in access.
below is my code that i'm working on from excel vba,
idA = Application.Index(wsPT.Range("B2:B" & wsPT.Cells(Rows.Count, "B").End(xlUp).Row), 0, 1)
idB = Application.Index(wsPT.Range("C2:C" & wsPT.Cells(Rows.Count, "C").End(xlUp).Row), 0, 1)
For k = LBound(idA) To UBound(idA)
For t = LBound(idB) To UBound(idB)
If idA(k, 1) = idB(t, 1) Then
.
.
End If
Next
Loop
any one could help me on this.
br,
I have the excel vba in my data and i wanted to convert the vba code in access.
below is my code that i'm working on from excel vba,
idA = Application.Index(wsPT.Range("B2:B" & wsPT.Cells(Rows.Count, "B").End(xlUp).Row), 0, 1)
idB = Application.Index(wsPT.Range("C2:C" & wsPT.Cells(Rows.Count, "C").End(xlUp).Row), 0, 1)
For k = LBound(idA) To UBound(idA)
For t = LBound(idB) To UBound(idB)
If idA(k, 1) = idB(t, 1) Then
.
.
End If
Next
Loop
any one could help me on this.
br,