arevilo
New member
- Joined
- Jan 29, 2021
- Messages
- 7
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2016 office 365
Hi p45cal,
column 19 did have a datetime field and on further thought, column 1 would be more appropriate. Please go ahead.
column 19 did have a datetime field and on further thought, column 1 would be more appropriate. Please go ahead.
Looking at your vba code, I'm assuming that the variable Delta is a holding variable for the smallest time difference? If so, the code looks atwhich is column S of the ORDERS sheet which is completely empty in the file you attached.Code:Sheets("ORDERS").Cells(j, 19)
That may explain the discrepency.
My PQ solution effectively looked at Sheets("ORDERS").Cells(j, 1) instead.
I'll await comment before posting incorrect code.