Hi,

I'm trying to figure out how to withe a macro that automaticall
inserts in the page footer/header the page number when a worksheet ha
more than one page.

I know how to do this manualy. As an example, if in Print Preview show
2 pages, and I want that the page number should start in that workshee
at no. 2, then:: View/Header and Footer/Custom Header/Cente
Section/[&Page]+1.

The question is again: how can this thing be done using a macro?
I tryied something like
ActiveSheet.PageSetup.CenterFooter = "&P"+1 but I get an error message
"Type mismath"

Thanks for any help

--
Message posted from http://www.ExcelForum.com