OilEconomist
Active Member
- Joined
- Dec 26, 2016
- Messages
- 421
- Office Version
- 2019
- Platform
- Windows
Hello and thanks in advance for your assistance. What is the VBA code to compare the following two entries.
(1) I want to make sure if the dates are the same. If so, proceed to the next part.
(2) If either entry is >9:30 AM, the I would like to reset that respective entry to 9:30 AM. e.g. .Cells(1, 1) would become .Cells(1, 1) = "2023-02-27, Mon @ 05:30 PM EST"
(3) Indicate which cell has the larger value.
.Cells(1, 1) = "2023-02-27, Mon @ 05:30 PM EST"
.Cells(1, 2) = "2023-02-27, Mon @ 08:30 AM EST"
Once again thanks!
(1) I want to make sure if the dates are the same. If so, proceed to the next part.
(2) If either entry is >9:30 AM, the I would like to reset that respective entry to 9:30 AM. e.g. .Cells(1, 1) would become .Cells(1, 1) = "2023-02-27, Mon @ 05:30 PM EST"
(3) Indicate which cell has the larger value.
.Cells(1, 1) = "2023-02-27, Mon @ 05:30 PM EST"
.Cells(1, 2) = "2023-02-27, Mon @ 08:30 AM EST"
Once again thanks!