I need to remove the absolute values in this code and place the words "SERVICE PART" in the cell that have a blank in column C. How do I do this on only the visible cells after the AutoFilter is applied, and what is it returns nothing? Please advise and thanks. -R-
'Need to put SERVICE PART on all filtered Blank cells
ActiveSheet.Range("$A$1:$D$440").AutoFilter Field:=3, Criteria1:="="
ActiveCell.FormulaR1C1 = "SERVICE PART "