Carly
Active Member
- Joined
- Aug 21, 2002
- Messages
- 370
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
Carly
This message was edited by Carly on 2002-10-18 04:19
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
Carly
This message was edited by Carly on 2002-10-18 04:19