Here is a snippet of code I have. What it is doing is looking at the row which was just pasted by the earlier code and clearing out everything that isn't a formula. The problem is in columns "N, P, R, T" the formula was "=if(isblank($L2),"",$L2)", which is just there to make data entry easier. If someone puts a date in L2, the sheet fills that into columns NPRT because the date will usually be the same for all those, and if it does change, it's only by a day, so it's easier to edit than punch in yyyy-mm-dd again.

Problem being sometimes people do change it, which means the formula I have in row two is probably gone by row ten. So I think I need to add another check to the code below, to see if we're currently in a cell that is in one of my watched columns, and if so, paste in the formula that would be something like:

=if(isblank($L_ourCurrentRow),"",$L_ourCurrentRow)

I am requesting assistance modifying the code below to achieve this.

For Each Cell In Range(Cells(Rows.Count, 2).End(xlUp).Offset(0, -1), _
    Cells(Rows.Count, 2).End(xlUp).Offset(0, 66))
     If Cell <> "" Then
        If Left(Cell.Formula, 1) <> "=" Then Cell.ClearContents
     End If     
  On Error Resume Next
Next Cell
This thread here is the closest thing I can find so far to what I'm trying to do, but my attempts to change the row check "r" to a column check aren't working.