View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
John Mc Twang John Mc Twang is offline
external usenet poster
 
Posts: 1
Default How can I use a calculation in a footer? (eg (=10+1)!!)

I need to use a calculation in a footer as an "additonal" page reference (the
sheet forms part of another document). I cannot reset the page number as I
need to use standard numbering in the document too. In full I need the
following in a footer:

Page x of y (standard option)
Page (x+10) of (y+10) of document H1234

Hope this makes sense!