ExcelBanter - Subtotaling within a Macro

Hi,

I'm writing my first macro, and I need some help. So I have my datase
selected D1: the end of the data. I want to replicate the behavior o
the subtotal pop up (where it asks me "Add subtotal to" and then I ca
select each colum I want to see a subtotal for: Columns E1 through th
last column.

When I record the macro, I get this:

Selection.Subtotal GroupBy:=2, Function:=xlSum, TotalList:=Array(15
16, 17 _
, 18, 19, 20, 21, 22), Replace:=True, PageBreaks:=False
SummaryBelowData:= _
True

I think the "TotalList" Thing is messing me up. How do I select th
Array from, let's say Column E through the end of the data? the numbe
of columns is variable.

Darn it, this is not making sense... anyone understand what i'
saying?

Explaining problems in excel through text is really difficult.

Thanks for reading.
Jo

--
Message posted from http://www.ExcelForum.com