LinkBack URL
About LinkBacks
Just add
Formula:
.Sheets(1).Range("B:B").NumberFormat = "mm/dd/yy"
immediately before the .SaveAs instruction
Just add
Formula:.Sheets(1).Range("B:B").NumberFormat = "mm/dd/yy"
immediately before the .SaveAs instruction
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks