VBA Macro issue: Adding Hyperlinks to six-digit numbers

Guessed · #1 10-08-2023, 03:22 AM

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.

yanyan9896 · #2 10-08-2023, 04:19 AM

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Find/replace - remove a space in 4 digit numbers	lalywizz	Word	5	10-08-2021 09:27 AM
Trying to change the last digit in a column of 10 digit entries	arkansawyer16	Excel	10	04-06-2020 02:03 PM
Adding PreserveFormatOnUpdate to macro that updates all hyperlinks within a document	JellehFishh	Word VBA	5	03-17-2020 02:47 PM
Regex/wildcard search for dates with 2-digit and 4-digit years	Marrick13	Word VBA	2	01-29-2016 07:04 AM
A challenging digit by digit manipulation, rotate the digit in range of 0 to 9	laucn	Excel Programming	14	05-17-2015 12:12 PM