Opening grouped cells automatically

[Ben01]

Hi guys,

I need some help.
I have a couple of groups of columns grouped, i.e. separate groupings of 5 columns.
Certain cells within various groups have hyperlinks that are linked to certain cells that are within other groups.
If a group is closed (minimized with the '+' sign displayed) and I click on a hyperlink to a cell within this group the cell does not display as it is obviously hidden due to the group being closed.
I then have to click the plus sign at the top to display the cell I was taken to with the hyperlink. This sometimes leads me to losing my place and not realizing where the link has taken me to.
Is there a way to automatically ungroup the columns I have been taken to by the hyperlink so that the cell is selected and displayed and not hidden?
Thanks for the help guys.

 

[Ben01]

Hi Gary, I previously had a sheet running with 4 sets of columns grouped.

Recently the sheet crashed and since it has been restored I seem to have lost the grouping of them. I have tried to regroup the correct columns together and nothing happens. I removed the code as thought this may be affecting it and tried to group but also didn't work.

Any help would be much appreciated please?

Thank you

 

[Gary McMaster]

I've only tried grouping a couple of times out of curiosity. I couldn't begin to tell you how to create an intelligent structure using that feature.

I doubt if the code had anything to do with it. The code simply toggles visibility of the row(s).

Gary

 

[Ben01]

Thanks anyway Gary, just doesn't seem to want to group the columns I want, can't do any grouping whatsoever, seems very strange.