Worksheet_FollowHyperlink - specific column only?

[NewYears1978]

With Worksheet_HyperlinkFollow is it possible to specify only specific column.

I have this code that bypass an Excel bug when following hyperlinks that require a logged in website (cookie issue bug in Excel MS never fixed)

Please Login or Register  to view this content.

Basically I want to use the code for two different columns so they would each have a different URLs set in the strAddress variable. Is there a way to say only if column U was clicked to set the strAddress?
I would then set one for column U and one for column W and have the URL int he strAddress different in each. Is probably simple but I am striking out.

Second part of the question - is it possible to change this formula to work in vba (would be copied down so has to retain copy down values not static cell values)

Please Login or Register  to view this content.

I know how to reference a cell with offset but it's the RIGHT LEN SEARCH part I don't know how to do in VBA (if possible).

[cytop]

You can simply check the objLink.Range address to see which column contains the clicked hyperlink. However, it is already navigating to the link before the event fires.

A workaround - edit a hyperlink so it refers to a 'Place in this document', add the address of the cell which contains the hyperlink to the Cell reference box and add a description as the cell value.

Basically what you are doing is defining a hyperlink to the cell containing the hyperlink - pointless, maybe, but nothing happens immediately except the Worksheet_FollowHyperlink will fire. In the event handler, check the text in the hyperlink cell and then use Workbook/Worksheet.FollowHyperlink to open the 'real' webpage.

Please Login or Register  to view this content.

Silly? Maybe, but if you want to 'pre-process' a hyperlink before navigating to where-ever, it's the easiest way to do it.