ClearOutLine Method
I've used the Subtotal method to generate totals in my
datafile, however when I use the Selection.ClearOutLine syntax, VBA removes the expansion/contraction lines with the little minus/plus buttons but it doesn't remove the ShowLevel buttons. When I do this manually in Excel ie Data, Group and Outline then Clear Outline it does. Can anyone provide the correct code to remove both the lines and showlevel buttons. Many thanks Jacqui |
All times are GMT +1. The time now is 06:25 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com