Hello Forum members,
I am trying to delete a row from a sheet sh2 for a value in column A which is not found in column A of sheet sh1.
The code runs until For i=3 because the first three values in column A of sh2 sheet are already there in sh1 sheet. But the code gives an error For i=4 because the value in row 4 and column A of sh2 sheet is not there in sh1 sheet. And in this case I want to delete row 4 of sh2 sheet. I am not sure how to handle this. Please assist me. The error I get is as follows...
Error: "Run-time error '1004': Unable to get the Vlookup property of the WorksheetFunction class.
Bookmarks