Need simple VBA script for Excel

C2 Software Development
1

hi, i figured out how to create order signal URLs in Excel.



In the Excel worksheet in B11:B200 are the URLs.



Can anyone send post a simple VBA script that will cycle through the rows in column B and send the signals to the Internet? Right now, I am just clicking the hyperlinks manually one by one to send out the signals.



Thanks.

2

Sub FollowHyperlinks()

Dim c As Range

For Each c In ActiveSheet.Range("b11:b200")

c.Hyperlinks.Item(1).Follow

Next

End Sub

3

sweet! thanks very much.