Insert page number-not header/ footer

[littleme]

Is there a way to make the number of active numbers appear in eg, H45,
and the current page number to appear in H44?

help?

 

[JE McGimpsey]

Is there a way to make the number of active numbers appear in eg, H45,
and the current page number to appear in H44?

What's an "active number"?

What do you mean by "current" - the page number that H44 is on? the page
number that the active cell is on?

 

[CyberTaz]

Hi littleme-

There may be something that can get this done through VBA, but I don't
know of any built-in fx or provision for doing so.

I'm sure you'll get some additional responses from respected sources on
the VBA possibility, so keep checking bac!

Good Luck |">)

 

[littleme]

sorry--- what i wanted was numbering like "4 of 6", 6 being the total
number of active pages and 4 being the current page... the kidn of
numbering that you can get in the header/ footer except i dont want it
in the header/footer but rather in a certain cell on each page
layout... on the first page it would be H44.... does that clarify
things...?

 

[Tom Stiller]

sorry--- what i wanted was numbering like "4 of 6", 6 being the total
number of active pages and 4 being the current page... the kidn of
numbering that you can get in the header/ footer except i dont want it
in the header/footer but rather in a certain cell on each page
layout... on the first page it would be H44.... does that clarify
things...?

And what would be the cell number on the second page?

 

[Bob Greenblatt]

sorry--- what i wanted was numbering like "4 of 6", 6 being the total
number of active pages and 4 being the current page... the kidn of
numbering that you can get in the header/ footer except i dont want it
in the header/footer but rather in a certain cell on each page
layout... on the first page it would be H44.... does that clarify
things...?

I don't know of a way to get the page number into a cell. However, it's easy
to get the total number of pages. Simply define a name "NumbPages" and in
the refers to, type: =get.document(50)
Now, in a cell simply place the formula =numbpages

 

[Bob Greenblatt]

I don't know of a way to get the page number into a cell. However, it's easy
to get the total number of pages. Simply define a name "NumbPages" and in
the refers to, type: =get.document(50)
Now, in a cell simply place the formula =numbpages

Actually I just found a way. Check this out:
http://www.dicks-blog.com/archives/2004/12/22/page-of-pages-in-a-cell/