Guest User

Untitled

a guest
Dec 11th, 2018
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.71 KB | None | 0 0
  1. Function Timestamp(Reference As Range)
  2.  
  3. If IsNumeric(Application.Caller.Text) = False Or Application.Caller.Text = "0" Then
  4. If InStr(Reference.Value2, "generated correctly") > 0 Then
  5. 'Debug.Print (Application.Caller.Address & " test2")
  6. Timestamp = CStr(DateDiff("s", "01/01/1970 00:00:00", Now()) * 1000 + Int(1000 * Rnd))
  7. Else
  8. 'Debug.Print (Application.Caller.Address & " test1")
  9. Timestamp = ""
  10. End If
  11. Else
  12. Timestamp = Application.Caller.Text
  13. 'Debug.Print (Application.Caller.Address & " 212 " & Application.Caller.Text)
  14. End If
  15.  
  16. 'Debug.Print (Application.Caller.Address & " 121 " & Application.Caller.Text)
  17.  
  18. End Function
Add Comment
Please, Sign In to add comment