So I am trying to find the end of a column and input an if statment withing those 70 something cells. Below is my script any ideas??
FinalRow = Cells(Rows.Count, 2).End(xlUp).Row
Range("A2" & FinalRow).Formula = "=if(F2="","", Today())"
Range("A2").Copy Destination:=Range("A2" & FinalRow)



FinalRow = Cells(Rows.Count, 2).End(xlUp).Row
Range("A2" & FinalRow).Formula = "=if(F2="","", Today())"
Range("A2").Copy Destination:=Range("A2" & FinalRow)


