Grouping & Outlining
I have a spreadsheet with 1000 rows of data and 4 layers of outlines. Some
of the collapsed items have only a few rows within the "+", while others have
100 rows within the "+".
When a users clicks one of the "+" items in the outline that has more than a
few rows, Excel shifts the users' "view" of the spreadsheet to the bottom of
the expanded item. I would like the users action of clicking a "+" to move
the user's view and cursor to the top of the expanded section.
Is there any VBA code to do this?
Thank you for your assistance.
Thx
MSweetG222
|