Hello,
The following code is not allowing me to integrate the "lastrow" formula and is creating 0's well past the data range.
On Error Resume Next
With ActiveSheet.Range("N2:N2" & Cells(Rows.Count, 2).End(xlUp).Row).SpecialCells(xlCellTypeVisible)
.Cells.FormulaR1C1 = "=RC[-2]"...