|I believe that this code does what you ask, but I had to change Communication History to Communication_History. |
It appears that building the Hyperlink in VBA doesn't work correctly if there is a space in the sheet name. It throws up a Reference Is Not Valid error when you try to use the Hyperlink.
'Set Row For First Link
linkRw = 1
'Loop Through Rows 4 - 3004
For rw = 4 To 3004
'Build Hyperlink By Appending Link Row Variable, Place In Column A
Anchor:=Cells(rw, 1), Address:="", _
SubAddress:="Communication_History!K" & linkRw, _
TextToDisplay:="Communication_History!K" & linkRw
'Increment Link Row By 26
linkRw = linkRw + 26
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.
message edited by DerbyDad03