adding page breaks to each subtotal 1

[daveonion]

hI,
I'ran the code to add subtotals to a spreadsheet, however when it is printed out the user wants each different group to be on a seperate page, any idea on how to do it
thanks for any help

Dave

 

[SkipVought]

Hi,

If you're using the Subtotal Wizard, there's an option button for page break.

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[daveonion]

hi skipvought,
the code I am using is

Selection.Subtotal GroupBy:=1, Function:=xlSum, _
TotalList:=(6)

is there another way to include page breaks too? Can you use the wizard by writing vb code to execute it?

 

[Loomah]

Hi
You need to add this parameter to your subtotal code

PageBreaks:=True

Happy Friday
;-)

If a man says something and there are no women there to hear him, is he still wrong?

 

[daveonion]

thanks, works perfectly

 

[SkipVought]

Dave,
My point was that you DON'T need to code what you want to do, unless you have a buring desire to maintain something that otherwise does not need to be maintained (which 99.9% of user code does).

The Subtotal Wizard DOES what you seem to want to do! So why write code, unless its an academic exersize.



Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[daveonion]

hi skipvought, the actual macro isn't for me instead its for 25 users who don't want to know the ins and outs of excel. So to make it easy for them i'm writing macros to format loads of different workbooks