L
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?
and the current page number to appear in H44?
help?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
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?
C
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 |">)
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 |">)
L
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...?
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...?
T
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?
B
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
B
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/