&[pages]

S

samart

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
 
B

Bob Phillips

Record a macro to do it.

--
HTH

Bob Phillips

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