VBA excel worksheet: show only Grand Total

Cameo

Registered User.
Local time
Today, 13:11
Joined
Aug 5, 2009
Messages
34
I want to have the Excel file show the data and end with a Grand Total row (number of rows), no subtotals. Anyone know how to do this, please?
 
What code are you using to create the Excel sheet?
 
createobject("Excel.Application")
ActiveSheet.Outline.ShowLevels won't work. I only want Level 1 and Level 3. I just want the data, then a count of rows.
 
Last edited:

Users who are viewing this thread

Back
Top Bottom