VBA run-time error 1004 with hyperlinks.add

I've encountered a run-time error '1004': Application-defined or object-defined error and the debugger highlights the following code:

Please Login or Register  to view this content.

The odd thing is that this error only displays once the loop has reached row 20349. For the life of me, I can't figure out this out. There is nothing different about row 20349 and there are a total of about 45,000 rows in the worksheet.

-- Full Subroutine --

Please Login or Register  to view this content.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)


Also, why are you adding hyperlinks that don't link to anything? You could just add text with maybe a cell comment.

Is that the only purpose of the hyperlinks?

This will run Macro1 when you select a cell in column T that has the text "Update"

To install this code:

• Right-click on the sheet tab
• Select View Code from the pop-up context menu
• Paste the code below in the worksheet's code module

Please Login or Register  to view this content.