'is there a way to add a word to a specific column?

The code I'm currently using only allows me to filter then replace certain values. Is there a way for me to filter for lets say column M filter for 0 and replace everything in column B to "not need". the code im currently using allows me to filter for 0 then uses a find and replace for a certain column for a certain word. I want to be able to do it for the whole column regardless of what's in the column. the code im using is below

.AutoFilter field:=6, Criteria1:="0"
Columns("F").replace What:="0", Replacement:="Not Needed", _
      Lookat:=xlPart, searchOrder:=xlByRows, MatchCase:=False, _
      Searchformat:=False, ReplaceFormat:=False
Worksheets("Sheet1").AutoFilterMode = False

excel vba

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source

'is there a way to add a word to a specific column?

Sources

Related Questions