I need to use an autofilter and then update columns using the filldown function. The problem is that I don't know what the first row will be. Is there a way to determine the first visible row in a column within a named range and then insert a formula into that cell.
Selection.AutoFilter Field:=12, Criteria1:="*Comp*"
Selection.AutoFilter Field:=17, Criteria1:="*Exp*"
If Selection <> 0 Then
Range("P7").FormulaR1C1 = "=EOMONTH(Now(),0)"
Range([P7], Cells(Rng.Row, "P")).FillDown