Simple Find and Delete Row in Excel

[ledelato]

Hi forum,

I'm new to programming VBA (today). I spent a good deal of the day trying to figure out how to automate this simple process:

search through my worksheet for the word "elementary"
delete the row where I found the word


Should be a simple iteration with find and delete methods? Couldn't find very clear guides or examples for how to use the find and delete methods for ranges.

 

[SkipVought]

Hi,

Have you checked out the AutoFilter feature?

Have you turned on your Macro Recorder to record a process?

Skip,

_[red][/red]