.Hyperlinks.Add Error Midway through Routine

Hello, I have been staring at this code for over a day now and cannot figure out why it works great for over 60K times and then it throws an error when I get to the 60K+ iteration.

I am running a routine that is performing quality control checks on a data set that is over 600,000 cells. It checks various things, and when it finds an error it writes the error to the sheet that is logging errors. One of the things it does is writes a hyperlink to the cell where the data was found.

It gets through almost all of 3865 rows of data being inspected and then it fails on very last column of the data set (column 175). See below image.

QC Report Fail Point.PNG

The error I am getting is: "1004 | Application-defined or object-defined error"

I have isolated the error to the following code area:

    cAddress = g_cSheet.Cells(cRow, cCol).Address
    anchorCol = FindColumn(QCSheet, QCCol04) 'anchor column'
    Set aAddress = QCSheet.Cells(qcLastRow + 1, anchorCol)
    saAddress = "'" & g_cSheet.Name & "'!" & g_cSheet.Cells(cRow, cCol).Address
    stText = "Go to " & cAddress & " in the '" & g_cSheet.Name & "' sheet."
    ttDisplay = g_cSheet.Name & " " & Replace(cAddress, "$", "")
    
    With QCSheet
        .Hyperlinks.Add _
            Anchor:=aAddress, _
            Address:="", _
            SubAddress:=saAddress, _
            ScreenTip:=stText, _
            TextToDisplay:=ttDisplay
    End With

I have checked the variables and they are all defined and present. When it gets to this point the .hyperlinks.add portion throws the above-noted error.

The data being evaluated is no different at the point it fails then a hundred other cells it evaluates perfectly fine. see below image.

QC Report Fail Point - Source Data.PNG

I appreciate the help. I have run out of ideas to try to resolve the error.