How do I delete a name from a column of names

Closed
Doug - Mar 3, 2010 at 04:55 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 4, 2010 at 05:52 AM
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

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Mar 4, 2010 at 05:52 AM
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
0