Guest User

Untitled

a guest
Jan 17th, 2019
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.42 KB | None | 0 0
  1. Sub NotEmptyDate()
  2.  
  3. Const cSheet As String = "Sheet1"
  4. Const cCol1 As String = "A"
  5. Const cCol2 As String = "E"
  6. Const cFirst As Long = 2
  7. Const cLast As Long = 1000
  8.  
  9. Dim i As Long
  10.  
  11. With ThisWorkbook.Worksheets(cSheet)
  12. For i = cFirst To cLast
  13. If Not IsEmpty(.Range(cCol1 & i)) Then
  14. .Range(cCol2 & i) = Date
  15. End If
  16. Next
  17. End With
  18.  
  19. End Sub
Add Comment
Please, Sign In to add comment