Archive of Mr Excel Message Board
Back to Data in Excel archive index
Back to archive home
inserting subtotalsPosted by SteveM on August 30, 2001 6:05 AM
I tend to use a lot of subtotals and find it cumbersome to use the fx key or type in "=subtotal(9,". Does anyone have any ideas as to how I can create VBA script to insert =subtotal(9, [without making it a label] then have the script return control to the Excel sheet and allow me to select the range I want to subtotal?
Did you consider...Posted by Mark W. on August 30, 2001 6:54 AM
...using the Data | Subtotals... menu command?
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store
to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.