i need to know how to add a page to the &[pages] command

in the previous version of excel we wrote &[page] of &[pages]+1

first page number set at 2

this would give us sht 5 of 5 when there were only 4 sheets

giving us the ability to have sheet 1 from a different file

Record a macro to do it.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"samart" wrote in message
...
i need to know how to add a page to the &[pages] command

in the previous version of excel we wrote &[page] of &[pages]+1

first page number set at 2

this would give us sht 5 of 5 when there were only 4 sheets

giving us the ability to have sheet 1 from a different file