markkeith
09-02-2020, 05:13 AM
Hi All, lets say I have a numeric data on Sheet1 Range A1 to find from Sheet2 Range A1:A40 using Vlookup. When I click the command button, I want to delete that row where data was match or found and display message if nothing found.
I know there must be something more for this code to work but I don't what it is.
Private Sub btnReturn_Click()
Application.VLookup(Activesheet.Range("A1").Value, Sheet2.Range("A1:A40"), 1, False).EntireRow.Delete
End Sub
I know there must be something more for this code to work but I don't what it is.
Private Sub btnReturn_Click()
Application.VLookup(Activesheet.Range("A1").Value, Sheet2.Range("A1:A40"), 1, False).EntireRow.Delete
End Sub