Comparing rows on one sheet to list on other

  • Thread starter Thread starter stevem
  • Start date Start date
S

stevem

Ok, after a little investigation (mainly adding some MsgBoxes) in th
code to see what variables are what at specific times, I found out tha
the variable res is being set to "Error 2042" on every pass
reguardless if there is a match or not.

Don't know why, or what that is, or how to fix it, but figured I'd giv
you as much info as I possibly can.
 
Tom's code is comparing the values in column H (of Elements) with the values in
column A of (of Servers).

Is that what you wanted?

If no, then change those columns ("H" or "A") to what you want.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Comparing rows on one sheet to list on other 1
Comparing rows on one sheet to list on other 2
Resize to last entry in row and copy to sheet 1 3
Compare values and place variable value on sh2 2
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
compare value of cell in one sheet to range of another sheet 3
select case syntax to other sheets 5
compare all matches 3

Back
Top