MrExcel Publishing
Your One Stop for Excel Tips & Solutions

inserting subtotals


Posted 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?


Posted by Mark W. on August 30, 2001 6:54 AM

Did you consider...

...using the Data | Subtotals... menu command?