I am adding hyperlinks to a excel sheet by writing a macro. After 65502
number of hyperlinks i am not able to add the hyperlinks in excel. Is there
any limitation regarding the number of hyperlinks in a excel sheet? Here is
the macro I have used

Sub HyperLink_Test()

' Local Variables
Dim nWorkSheet As Worksheet
Dim nRange As Range
Dim strAddess As String, strDisplayText As String

' Step 1 : Loop through all worksheets
' 1a : Clear all current hyperlinks
Worksheets("Sheet1").Range("A:Z").ClearContents
' 1b : Create Linked index list

Dim i As Long
Dim j As Long


Dim count As Long

count = 0

For i = 1 To 70000

Set nRange = Worksheets("Sheet1").Range("A:Z").End(xlUp)
If (i 1) Then
Set nRange = nRange.Offset(i - 1, 0)
End If
For j = 1 To 10



strAddess = "'" & XYZ & "'"
strDisplayText = "HyperLink : "
Worksheets("Sheet Index").Hyperlinks.Add Anchor:=nRange,
Address:="ddd", SubAddress:="", TextToDisplay:="ab"
count = count + 1
If count = 65530 Then
GoTo End1
End If
Set nRange = nRange.Offset(0, 1)

Next j


Next i

End1:



End Sub