ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Grouping & Outlining (https://www.excelbanter.com/excel-programming/435152-grouping-outlining.html)

MSweetG222

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


All times are GMT +1. The time now is 03:35 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com