I'm attempting to create a macro that will empty cells in rows that contain a specific value in a specific column. Finding the value using "For Each" is not difficult, however choosing the range to clear afterward is difficult for me.
What I've tried is
Dim WorkRng As Range
Set WorkRng = Range("AO8:AO108")
For Each V in WorkRng
If V.Value = "the value I'm looking for" Then
What I am trying to do with the V.Columns line is to select the cells in the row where the value is found from column A to column AM. It seems to clear cells to the right of the value found only.