| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Subtotal using VBA
Win XP Pro
Excel 2002 I'm trying to figure out a way to envoke subtotalling with VBA. I would have to set all of the parameters of the subtotal feature in VBA, with no human interaction. Can this be done? And if so, how? Thanks Tom S. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Subtotal using VBA
MsgBox Application.Subtotal(9, subtotalrange) or MsgBox Application.Subtotal(9, range("a2:a200")) -- Don Guillett SalesAid Software "Tom S" wrote in message ... Win XP Pro Excel 2002 I'm trying to figure out a way to envoke subtotalling with VBA. I would have to set all of the parameters of the subtotal feature in VBA, with no human interaction. Can this be done? And if so, how? Thanks Tom S. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Subtotal using VBA
I'm trying to actually subtotal the worksheet so that it looks and acts like
if the user had gone to the menu options of 'Data'::'Subtotal', and completed that process. Any suggestions? "Don Guillett" wrote in message ... MsgBox Application.Subtotal(9, subtotalrange) or MsgBox Application.Subtotal(9, range("a2:a200")) -- Don Guillett SalesAid Software "Tom S" wrote in message ... Win XP Pro Excel 2002 I'm trying to figure out a way to envoke subtotalling with VBA. I would have to set all of the parameters of the subtotal feature in VBA, with no human interaction. Can this be done? And if so, how? Thanks Tom S. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Subtotal To Include Item Description On Subtotal Line | Excel Discussion (Misc queries) | |||
| sort macro, subtotal and add lines after subtotal | Excel Discussion (Misc queries) | |||
| pasting to subtotal lines without replacing hidden -non-subtotal l | Excel Discussion (Misc queries) | |||
| Bolding the subtotal lines automaticlly When using the Subtotal fu | New Users to Excel | |||
| Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
![Tom S[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
