Ark68
Well-known Member
- Joined
- Mar 23, 2004
- Messages
- 4,564
- Office Version
- 365
- 2016
- Platform
- Windows
I have this line of code:
The value found with the vlookup is 44764.29167, representing a date/time of July22, 2022 7:00 AM.
When I apply this formatting to cell(drow,14), the result is 2022-07-22, not 7:00 AM 22-Jul as desired.
Thoughts?
Code:
.Cells(drow, 14) = Format(Application.WorksheetFunction.VLookup(luVal, .Range("U3:X60"), 3, False), "h:mm AM/PM dd-mmm")
When I apply this formatting to cell(drow,14), the result is 2022-07-22, not 7:00 AM 22-Jul as desired.
Thoughts?