Quote:
Originally Posted by Guessed
I think the issue is on the mins line. That is one line that I didn't check on your provided code and it appears to start from the wrong spot. Change the 4 to 3 eg
Code:
mins = CInt(Mid(aRng.Text, 3, 2))
You can debug these things yourself by stepping through the code and hovering over the variables after the line has executed to see what value they have. |
Thank you for pointing out the issue with the "mins" line in the provided code. I apologize for not checking it thoroughly. I appreciate your suggestion regarding debugging. Stepping through the code and examining the variable values after execution will indeed help identify and resolve such issues in the future.
Once again, thank you for your keen observation and valuable input. I truly appreciate your assistance.