That didnt work eitherIts still pasting as General
I guess i'll just have to format each column individually after pasting
e.g.
![]()
Range("A4:A100").NumberFormat = "dd/mm/yyyy"
That didnt work eitherIts still pasting as General
I guess i'll just have to format each column individually after pasting
e.g.
![]()
Range("A4:A100").NumberFormat = "dd/mm/yyyy"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks