View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
stevec stevec is offline
external usenet poster
 
Posts: 177
Default cycle through hyperlinks in column b

This macro doesn't work. It's supposed to follow the hyperlinks on each row
on columnn b. I get the following error: "Run-time error '9': Subscript
out of range"

any suggestions? thanks...

Sub FollowHyperlinks()
Dim c As Range
For Each c In ActiveSheet.Range("b11:b200")
c.Hyperlinks.Item(1).Follow
Next
End Sub