Excel 2007 Find and Select
Hi I am trying to write code/macro to look for the word production in column A. Once the word is found, I want to select the cell containing production and all the cells below it and delete it. The word production will always be in column A but it may be on a different row each time this code is run. Today it may be found in cell a585 but next week when I use it, it may be on cell a1245. Below is my code. The issue is that this is deleting the entire column instead of deleting the cell containing the word production and all cells below it. I think I am missing a line where the cell containing production is actually selected. Any asssitance is greatly appreciated.
Selection.Find(What:="production", After:=Cells(1, 1), LookIn:=xlValues _
, LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _