View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Erin Erin is offline
external usenet poster
 
Posts: 75
Default Successive numbers

I have a cell that says "Sheet 1 of 24". The cell underneath that says
"Sheet 2 of 24" and so on. Does anyone know a formula that can be dragged
down that will update the next cell in succession for the rest of the sheets?