"type mismatch" error

[bbhockey]

Hello,
I am trying to compare a list of offline values in one worksheet, and to find those vlaues in another worksheet. I was wondering why i get "type mismatch" in the line that is "If OffValue = NonList.Range("A4", "K110").Value Then". I am trying to compare the offline values in the offline sheet to the other sheets. i want to select the range to compare. is there a better way? if the values are found on the list after comparing i want to delete them as well

Please Login or Register  to view this content.

[bbhockey]

if this is not clear, i can try to explain it better, but my main concern is why am i getting a mismatch error?

[stnkynts]

This might be causing one of the issues. What is the purpose of "Delete"?

Please Login or Register  to view this content.

Also you are trying to compare one value to the values in multiple cells at the same time. There is an issue with the way you are doing it. Would probably need to use .Find or another method.

Submit an example worksheet with before and after descriptions.

[bbhockey]

This might be causing one of the issues. What is the purpose of "Delete"?

Please Login or Register  to view this content.

So i have a list in the "Offline" that i want to check on List1, and if the values in offline are in list1, i want to delete the value on List1

[stnkynts]

Submit an example worksheet with before and after descriptions.

[bbhockey]

ExampleWorkbook.xlsx

this is my example workbook. i have explained what i am trying to do inside the file.


EDIT

my real workbook has values throught a range A1:K110 as well

[stnkynts]

Please Login or Register  to view this content.

[kvsrinivasamurthy]

Try this code

Please Login or Register  to view this content.

[stnkynts]

my real workbook has values throught a range A1:K110 as well

Please Login or Register  to view this content.