Comparing two unsorted excel columns

[ProTester]

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.

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