Subtotal using VBA

T

Tom S

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.
 
D

Don Guillett

MsgBox Application.Subtotal(9, subtotalrange)
or
MsgBox Application.Subtotal(9, range("a2:a200"))
--

Don Guillett
SalesAid Software
[email protected]
Tom S said:
Win XP Pro
Excel 2002

I'm trying to figure out a way to envoke subtotalling with VBA. I would
Click to expand...
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?
 
T

Tom S

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?
 
Top