Delete Row based on entered values

I have seen many different topics that involve deleting a row based on a set condition. However, I am having trouble adjusting their codes for a variable condition.

As you can see in the below picture, there is a list of baseball players and to the right is the name of the "current player". If I click a button, I want to have a code that automatically deletes the entire row that has the same name as the current player. Anyway I can do this? I didn't know how to insert parameters into the code, if that's how you do it.

I tried to do the following, but I still don't know how to delete the row. The indented line is the spot I am having trouble at

Please Login or Register  to view this content.