i have 2 worksheet which is hyperlinked. 1st sheet contain 1000 rows and 2 sheet 1,50,000 rows. i wrote vba code to hyperlink between sheets.
But i got an 1004 error (Application-defined or object-defined error) on 66199 row and also i couldn't able to hyperlink that cell manually. Please advise.
i need to hyperlink all the 1,50,000 rows.
If all the other hyperlinked rows function as desired ... then there is something unseen in row 66199 or in the hyperlink on Sheet1 connected to Sheet2 Row 66199.
I would start by checking the formatting in those cells / sheets.
Review your hyperlink coding for those cells / sheets.
Have you made a recent change to the workbook that might have affected those areas ?
Sh6_Row=Sh6.usedrange.rows.count
For Each C1 In Sh6.Range("A5:A" & Sh6_Row)
If InStr(C1.Value, "Details of") = 0 And InStr(C1.Value, "Total for") = 0 And InStr(C1.Value, "TOTAL") = 0 Then
Sh6.Hyperlinks.Add Anchor:=C1, Address:="", SubAddress:="Symbol_Mismatch!THENN" & Replace(Replace(Replace(C1.Value, "+", "PLS"), "-", "HYP"), " ", "SPACE"), TextToDisplay:=C1.Value
End If
Next C1
Error occur while the C1 come to 66199 row.After that cell hyperlink not working . Please advise.