PDA

View Full Version : Hyperlink Issue



prmanimaran
12-27-2016, 09:43 AM
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.

Logit
12-27-2016, 05:59 PM
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 ?

prmanimaran
12-28-2016, 03:25 AM
Code for hyperlink:

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.