Advertisement
Guest User

Untitled

a guest
Jun 20th, 2019
84
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.20 KB | None | 0 0
  1. JAN/19
  2. JAN02/19
  3. JAN19
  4.  
  5. If IsError(DateValue("01 " & Left(Cells(1, 1), 3) & " 19")) = True Then
  6.  
  7. MsgBox "Oops, " & Left(Cells(1, 1), 3) & " is not a valid month abbreviation"
  8.  
  9. End If
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement