bobbyexcel
Board Regular
- Joined
- Nov 21, 2019
- Messages
- 88
- Office Version
- 365
- Platform
- Windows
Can someone help me on this error please..
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
type mismatch error on Array date format
- Thread starter bobbyexcel
- Start date
StephenCrump
MrExcel MVP
- Joined
- Sep 18, 2013
- Messages
- 5,408
- Office Version
- 365
- Platform
- Windows
Based on just this code snippet, I suggest you first check:
- What's in arr(i,11) when the error occurs?
- How have you declared mykey?
- What's in arr(i,11) when the error occurs?
- How have you declared mykey?
Upvote
0
Fluff
MrExcel MVP, Moderator
- Joined
- Jun 12, 2014
- Messages
- 90,659
- Office Version
- 365
- Platform
- Windows
Duplicate to: Excel VBA Closest Time of the Job and status in another cell
In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.
In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.
In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.
In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.
Upvote
0
- Status
