Using a Range of cells in a FollowHyperlink function

I am trying to write some code that looks at a column of data, a defined range of say A1:A100. Each of the cells in the range have a string value in each of them (project names). Each of these are hyperlinked to themselves (I use some other code for this which does it automatically). My wish is for this new code to detect which hyperlinked cell in the range has been clicked and then go to a different sheet and copy the value of that cell to a cell on the new sheet.

I have been able to do this already, but only when specifying a particular cell in the range, and can't figure out how to make it look at a true range of cells.

Here is the code that works now for a single cell (A1)

Please Login or Register  to view this content.

Anyone have any ideas how I can chnage this to cover a range of cells i.e. A1:A100?

Thanks

Wow, so quick and so simple. I can't tell you grateful I am. That was the last piece of my puzzle.