How do I delete a name from a column of names Closed

Question

Hello,
I'm working on  a spreadsheet using a simple macro were it adds a name of a person to A1:A500 and also sorts them. I would like know how I can delete a name from my list using the same type of macro by typing the name in and press a delete button, just like when using the add button.

Thank You for Help

rizvisa1 · Answer

You would need to first find the the location or row number of that "name" and then delete it. if you want to delete row, it is

rows(5).delete
this will delete row 5

how ever if you want to only delete cell, you also have to decide how cells would move, left, or up etc

How do I delete a name from a column of names

1 response

Similar discussions

Subscribe To Our Newsletter!