How to make Macro that prompts for user input and deletes a row that contains that value?
Posted by david on December 21, 2001 9:53 AM
I need to create a macro that prompts the user to enter in a value, search the spreadsheet cells for that value, if it finds it, highlight the entire row and delete it from the spreadsheet.
I've been able to do this on my own, but only by manually entering in the value and then manually selecting the row and deleting it.
I just need to make the next step and automate this process. I hope there is an easy way to do this?