copying page setup to worksheets

[tcorradi]

I go through and do the page setup work to get my
worksheet to print how I want. I want to insert a new
worksheet into the workbook, but I would like to copy the
page setup information to the new worksheet.. Does anyone
know if that is possible? And if so, How?

 

[Earl Kiosterud]

t,

One possibility is to copy an existing sheet, and clear the existing data.
A macro is great for this to automate it. You may have headings, formulas
and formatting, etc, that will be the same anyway (I'm guessing, since you
want to use the same page setup settings).

 

[Guest]

Thanks Earl

-----Original Message-----
t,

One possibility is to copy an existing sheet, and clear the existing data.
A macro is great for this to automate it. You may have headings, formulas
and formatting, etc, that will be the same anyway (I'm guessing, since you
want to use the same page setup settings).

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------




.