| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how in excel, return page numbers in to cell ?(like date function
current file name how returned in cell in excel , same way in excel- current
page number to be returned in to a cell, how to do it? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how in excel, return page numbers in to cell ?(like date function
=RIGHT(Cell("filename",A1),5)
the last argument is the number of characters in the filename. Current page number ? -- ~roar selva skrev: current file name how returned in cell in excel , same way in excel- current page number to be returned in to a cell, how to do it? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how in excel, return page numbers in to cell ?(like date funct
DEAR ROAR HANSEN
TO MAKE CLEAR , I AM LOOKING FOR, CURRENT PAGE NUMBER OF EXCEL SHEET ,TO BE RETURNED TO EXCEL CELL IN CURRENT PAGE IT SELF . WHERE PAGE NUMBERS ARE APPEARING IN EXCEL, ONLY IN HEADER FOOTER ONLY I WOULD LIKE TO PULL THE PAGE NUMBERS TO CELL, SO THAT I WANT TO USE WITH FORMULA COULD U HELP ME "Roar Hansen" wrote: =RIGHT(Cell("filename",A1),5) the last argument is the number of characters in the filename. Current page number ? -- ~roar selva skrev: current file name how returned in cell in excel , same way in excel- current page number to be returned in to a cell, how to do it? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how in excel, return page numbers in to cell ?(like date funct
Selva,
Regarding File name, the function CELL will return the sheet name with whole path (see Help). By combining with LEFT, RIGHT or MID, you can select part of the path. Try the excample I gave. Regarding Page number, there are no argument similar to "Filename". There have been some questions about that before, but no replies. I don't think there is a solution. selva skrev: DEAR ROAR HANSEN TO MAKE CLEAR , I AM LOOKING FOR, CURRENT PAGE NUMBER OF EXCEL SHEET ,TO BE RETURNED TO EXCEL CELL IN CURRENT PAGE IT SELF . WHERE PAGE NUMBERS ARE APPEARING IN EXCEL, ONLY IN HEADER FOOTER ONLY I WOULD LIKE TO PULL THE PAGE NUMBERS TO CELL, SO THAT I WANT TO USE WITH FORMULA COULD U HELP ME "Roar Hansen" wrote: =RIGHT(Cell("filename",A1),5) the last argument is the number of characters in the filename. Current page number ? -- ~roar selva skrev: current file name how returned in cell in excel , same way in excel- current page number to be returned in to a cell, how to do it? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how in excel, return page numbers in to cell ?(like date funct
See:
http://groups.google.com/group/micro...48489312cf3b50 -- Gary's Student "selva" wrote: DEAR ROAR HANSEN TO MAKE CLEAR , I AM LOOKING FOR, CURRENT PAGE NUMBER OF EXCEL SHEET ,TO BE RETURNED TO EXCEL CELL IN CURRENT PAGE IT SELF . WHERE PAGE NUMBERS ARE APPEARING IN EXCEL, ONLY IN HEADER FOOTER ONLY I WOULD LIKE TO PULL THE PAGE NUMBERS TO CELL, SO THAT I WANT TO USE WITH FORMULA COULD U HELP ME "Roar Hansen" wrote: =RIGHT(Cell("filename",A1),5) the last argument is the number of characters in the filename. Current page number ? -- ~roar selva skrev: current file name how returned in cell in excel , same way in excel- current page number to be returned in to a cell, how to do it? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| run a macro in a locked cell | Excel Discussion (Misc queries) | |||
| For Hector Miguel - Inserting page numbers in cell | Excel Discussion (Misc queries) | |||
| cell on one page equals cell on another page in excel? | Excel Worksheet Functions | |||
| Excel 97 SR-1 / Set date in a cell-have day track in another cell | Excel Discussion (Misc queries) | |||
| Excel worksheet function that will return the currency for a cell | Excel Worksheet Functions | |||
Hybrid Mode
