Carly
Active Member
- Joined
- Aug 21, 2002
- Messages
- 370
I was wondering if anyone could help me with this urgent query I have.
I am trying to subtotal a spreadsheet within a macro but I am unsure how many columns there will be each time.
When you record the subtotalling it puts in the column numbers (TotalList:=Array(5,6,etc) which is no good as one day there might be 5 and another day there might be 50.
Can this be done by somehow naming a range like in a Pivot Table?
Please help
I realise that I have posted this question before but I am struggling to get any further with my report, Everything I try seems to fail.
Carly
I am trying to subtotal a spreadsheet within a macro but I am unsure how many columns there will be each time.
When you record the subtotalling it puts in the column numbers (TotalList:=Array(5,6,etc) which is no good as one day there might be 5 and another day there might be 50.
Can this be done by somehow naming a range like in a Pivot Table?
Please help
I realise that I have posted this question before but I am struggling to get any further with my report, Everything I try seems to fail.
Carly