hyperlinks

[vincenzo345]

Hello everyone,

I have several rows of information (often times around 200). and in each row there is a hyperlink with information that I need to copy and paste in a new sheet. Im trying to automate this process with a macro but Im having difficulty with the hyperlink part.

S T R Hyperlinks Name Well Num Org ID Field Field Name
x x x 13659 x x 1862 x x x 29
x x x 23324 x x 9999 x x x 29
x x x 24912 x x 9999 x x x 29
x x x 25129 x x 9999 x x x 29

I tried multiple ways of following the hyperlink through vba but they havnt worked.

Since I have so many hyperlinks to go through and since im trying to automate this process, I'll need the macro to loop and go down the column 1 at a time.

so something Like:

dim x as integer
x=6

cells(4, x). Hyperlinks(1).follow

x=x+1

I tried using this to access the hyperlink and it hasn't worked.

can anyone help me to get this part of the macro working?

I have the rest of the macro working this is the last bit I need.
Thanks!!!