Oh, sorry!
I forgot to write DateValue before the actual date.
It is, basically:
![]()
Range("B" & lrTest - 1).value = DateValue("08/mm/2016") 'mm as month Range("B" & lrTest - 1).NumberFormat = "dd/mm/yyyy"
Oh, sorry!
I forgot to write DateValue before the actual date.
It is, basically:
![]()
Range("B" & lrTest - 1).value = DateValue("08/mm/2016") 'mm as month Range("B" & lrTest - 1).NumberFormat = "dd/mm/yyyy"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks