Hi there, this is no doubt a newb question, but I can't find anything
online.
I have a 'master' workbook containing various formulas (let's call
that WB1). I import customer data into WB1 as separate worksheets,
run my formulas, then copy out the resulting customer-specific
worksheets into a new workbook (let's call it WB2). WB2 has no VBA/
macros, the data is copied as straight values. I provide WB2 to the
customer electronically, and also provide a printed copy of each
worksheet in WB2. Here's my problem:
In WB1, I have a routine to format the printed version for each
worksheet in WB2. Paper size, margins, font, header/footer, etc. In
the footer I would like to have page x of x WORKSHEET pages. If each
worksheet is printed separately, that works fine. But if I print the
entire WB2 workbook in one shot, the footer displays page x of x
WORKBOOK pages. Is there a way around this? I am using this code to
get the footer:
With Worksheets(wsName).PageSetup
.CenterFooter = "&P of &N"
Thanks in advance, sorry if this is a bit confusing.
S.
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us in TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,500 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
