C Cameo Registered User. Local time Today, 13:11 Joined Aug 5, 2009 Messages 34 May 17, 2010 #1 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?
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?
boblarson Smeghead Local time Today, 11:11 Joined Jan 12, 2001 Messages 32,040 May 17, 2010 #2 What code are you using to create the Excel sheet?
C Cameo Registered User. Local time Today, 13:11 Joined Aug 5, 2009 Messages 34 May 17, 2010 #3 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: May 17, 2010
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.