Hyperlinks after a SORT
 

I having a problem when trying to create a 2 tab excel sheet, with
sort sequences that are different between the 2 tabs.

Tab1 contains the data that is used to generate Tab2 - so I have been
sorting Tab1 to begin in the sequence desired for Tab2. And after
completing formatting Tab2 then I sort Tab1. Once this done, the
hyperlinks that got from Tab 1 to Tab 2 still work, but the ones from
Tab2 to Tab 1 no longer work.

Is there an easy way of resetting the invalid hyperlinks in the Tab2?

I have thought of going through a final loop of the data on Tab1 over
the established hyperlinks to Tab2 and somehow obtaining the location
cell on Tab2 that needs to be changed, and then changing the hyperlink
on Tab2 to the correct new location.

I have not yet been able to obtain which cell on Tab2 needs to be
corrected based on the formulas I have been trying (namely
ActiveCell.Hyperlinks.Item(1).Address - but this is always empty for
some reason).

Not sure if this approach is the best.

Thanks in advance,
Enzo

Hyperlinks after a SORT
 

try
ActiveCell.Hyperlinks.Item(1).SubAddress

Also, look at the Hyperlink worksheet function in Excel help. It will sort
like any other worksheet function and may be what you are looking
for/simplify you life.

--
Regards,
Tom Ogilvy


"Enz" wrote:

I having a problem when trying to create a 2 tab excel sheet, with
sort sequences that are different between the 2 tabs.

Tab1 contains the data that is used to generate Tab2 - so I have been
sorting Tab1 to begin in the sequence desired for Tab2. And after
completing formatting Tab2 then I sort Tab1. Once this done, the
hyperlinks that got from Tab 1 to Tab 2 still work, but the ones from
Tab2 to Tab 1 no longer work.

Is there an easy way of resetting the invalid hyperlinks in the Tab2?

I have thought of going through a final loop of the data on Tab1 over
the established hyperlinks to Tab2 and somehow obtaining the location
cell on Tab2 that needs to be changed, and then changing the hyperlink
on Tab2 to the correct new location.

I have not yet been able to obtain which cell on Tab2 needs to be
corrected based on the formulas I have been trying (namely
ActiveCell.Hyperlinks.Item(1).Address - but this is always empty for
some reason).

Not sure if this approach is the best.

Thanks in advance,
Enzo