still learning
Well-known Member
- Joined
- Jan 15, 2010
- Messages
- 774
- Office Version
- 365
- Platform
- Windows
Hi
I've been using the following macro as part of a bigger one for a few years.
before 1/23/2021, it work fine
On 1/23/2021, didn't work. nothing happened when the macro was supposed to find the date. I didn't have time to mess with it, so I worked around it.
On the next day it worked fine and up until today.
This morning I went into two workbooks and the macro didn't finde today's date.
The first think I did was check the Desktop's Date. It is correct.....1/28/2021
I then changed the format of the date to different ones. It didn't help
I changed where today's' date is on the sheets to ....=today()..that didn't help
I opened a new workbook and worksheet. Ityped in t todays date in a cell in the range of the macro and copied the macro to it's new module. Didn't work
I tried a bunch of different formats and couldn't get it to work....again i tried ...=today()
any ideas???
mike
I've been using the following macro as part of a bigger one for a few years.
Excel Formula:
Sub gotodateday()
Dim C As Range
Set C = Range("B1:O1300").Find(Date)
If Not C Is Nothing Then C.Select
End Sub
On 1/23/2021, didn't work. nothing happened when the macro was supposed to find the date. I didn't have time to mess with it, so I worked around it.
On the next day it worked fine and up until today.
This morning I went into two workbooks and the macro didn't finde today's date.
The first think I did was check the Desktop's Date. It is correct.....1/28/2021
I then changed the format of the date to different ones. It didn't help
I changed where today's' date is on the sheets to ....=today()..that didn't help
I opened a new workbook and worksheet. Ityped in t todays date in a cell in the range of the macro and copied the macro to it's new module. Didn't work
I tried a bunch of different formats and couldn't get it to work....again i tried ...=today()
any ideas???
mike