 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / July 2006Page Number Problem
Hi there, hope you are fine... I'm new in this forum, and I have a doubt (a big doubt) about page number... Here is the problem: I have a long spreadsheet (about 320 pages), and I need to show the the current page number, in a sigle cell (A1, for example)... So, if a cell in page 1 is selected, in A1 we'll have "Page 1 of 320", otherwise if the selected cell is in page 20, now A1 will be showing "Page 20 of 320", and so on... I've tried use the PageBreaks.Count, but I get always the same result: "*Page 1 of 320*", it doesn't change to "15 of N", or "85 of N"... It would have to work as when we're in the Print Preview mode... scrolling (down or up), the message in StatusBar is always displaying the current page number (I can't use the header / footer to do this, but a single cell) !!! Tanks in advance, for any help Marcos.  Signaturesocram_06 just to clarify... are you talking about sheets or pages -- davesexce sorry, I was not so clear... I'm talking about pages... In header / footer the excel uses a macro to show the page number, doesn't it ??? I'd like to do the same, but not using header / footer, but a single cell, where I can see the page I am all the time... ***************************************** A friend told me to do this: (VBA) Insert, Name, Define: Add a name (PageNo) and the refers to is =get.document(64) In a cell in the column you want enter the formula =IF(ISNA(MATCH(ROW(),PageNo)),1,MATCH(ROW(),PageNo)+1) ***************************************** It works, but not in a single cell, like I need... If you need more details, please tell me and I'll try explain a bit better !!! Thanks a lot Marcos Signaturesocram_06 > sorry, I was not so clear... > [quoted text clipped - 21 lines] > Thanks a lot > Marcos View | Page Break Preview will always show what page you are on, but of course not in a single cell. If you ever do find what to put in A1 to show the current page, you'll have to freeze the top row to display that cell. Bill Bill Sharpe Wrote: > View | Page Break Preview will always show what page you are on, but > of [quoted text clipped - 4 lines] > > Bill Hello Bill, that's it... I'll freeze the top row, and then when a cell is selected or changed, according to its location (page), excel would count the pages (or page breaks), and the result would appear in A1... The code bellow is part of one that I have tried... Code: -------------------- Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim h Dim v h = Application.Excel4MacroSheets.HPageBreaks.Count + 1 v = Application.Excel4MacroSheets.VPageBreaks.Count + 1 Range("A1") = "Page " & v & " of " & h End Sub -------------------- How to complete or change this code to make it work ??? Best regards Marcos. Signaturesocram_06 I'm only guessing but, as A1 is always on page 1...... SignatureIan -- > > Hi there, hope you are fine... I'm new in this forum, and I have a doubt [quoted text clipped - 16 lines] > > Marcos. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.