![]() |
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