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

Try posting in this Excel-specific newsgroup

http://www.microsoft.com/office/comm...&lang=en&cr=US

"Austin" wrote:

> 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