&[pages]
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
|