Subtotal using VBA

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
MsgBox Application.Subtotal(9, subtotalrange)
or
MsgBox Application.Subtotal(9, range("a2:a200"))
--

Don Guillett
SalesAid Software
(e-mail address removed)
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?
 
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?
 
Back
Top