Reply to thread

Message: [QUOTE="Austin, post: 6412692"] Good Morning, I am working with some code that exports from Access to Excel and then subtotals in Excel. Like the code below: With xlTop.Range("A:P") .Subtotal GroupBy:=1, Function:=xlSum, TotalList:=Array(3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15), _ Replace:=True, PageBreaks:=False, SummaryBelowData:=xlSummaryBelow End With The problem is that the width of the recordset being subtotaled on can change (it will not necessarily be 15 columns wide). Is there a way to make this range dynamic? Thanks, Austin [/QUOTE]