Range("AM3:AM" & Lastrow).FormulaR1C1 = "NO"
            Range("AM3:AM" & Lastrow).Activate
            Selection.NumberFormat = "@"
can i reduce this code ? why do i have to activate the selection first can i just combine them ?