09-13-2018, 02:11 PM
Hi,
I've loaded two Attachments.
for every key in KEY_Column.
If key in SHEET A exists in SHEET B then check the entire row.
this code let me get the row number of the found key in SHEET B.
If I find a match then I check Attribute One, Two, Three, Four, etc... with this code:
What I am asking if there is a faster way to do the Attributes check rather than a For cycle.
Sorry, english is not my language.
I hope I cleared my issue.
Thank you
I've loaded two Attachments.
for every key in KEY_Column.
If key in SHEET A exists in SHEET B then check the entire row.
Code:
x = objXL.Application.Match(objMyWorksheet1.Cells(i,1).value, objXL.Sheets(sheet2)Range("A1:A"&rowCount2),0)
this code let me get the row number of the found key in SHEET B.
If I find a match then I check Attribute One, Two, Three, Four, etc... with this code:
Code:
For z = 2 To columnCount1 Step 1
rowA= trim(objMyWorksheet1.Cells(i,z).value)
rowB= trim(objMyWorksheet2.Cells(x,z).value)
If isnumeric(rowA) then rowA= Cdbl(rowA)
If isnumeric(rowB) then rowB= Cdbl(rowB)
If rowA <> rowBThen Call CheckRow(objMyWorksheet1,objMyWorksheet2,i,x,z)
What I am asking if there is a faster way to do the Attributes check rather than a For cycle.
Sorry, english is not my language.
I hope I cleared my issue.
Thank you