Paste value

[hujenx]

I have 2 sheets - Certificate (Sheet1) & ListOfProjects (Sheet2)
and am trying to test col K values in the Sheet2 against 2 cell values in Sheet1 and if true then paste a value from Sheet1 into col L of the same row (as the tested col K cell) in Sheet2.

I've used similar to the below before to do that, but in this case it just doesn't seem to work - what am I missing?


Sub DateStamp()


Dim N As Integer

For N = 10 To N = 638

If Sheets("ListOfProjects").Range("K" & N) < Range("Certificate!C8").Value Then
If Sheets("ListOfProjects").Range("K" & N) > Range("Certificate!C9").Value Then

Sheets("ListOfProjects").Range("L" & N) = Range("Certificate!C8").Value

End If
End If

Next N


End Sub

 

[Jerry Sullivan]

Revise to....

     For N = 10 To 638

 

[hujenx]

Thanks so much. When I look back again at the code that worked before that's so, don't know how I came to change it & didn't notice!