| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to extract the number of pages in a cell (Excel 2003)
Hi,
I would like to extract the total number of pages of an Excel file in a cell so that it is updated automatically. I need to mention the total number of the printed pages in my document (This document contains XX pages and may not be reproduced other than in full). Can you help me? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to extract the number of pages in a cell (Excel 2003)
hi, Vahid !
I would like to extract the total number of pages of an Excel file in a cell so that it is updated automatically. I need to mention the total number of the printed pages in my document (This document contains XX pages and may not be reproduced other than in full). *IF* your printed pages refers only to one worksheet (sheet1 ?) try creating/defining a name using xl4 macro-functions (i.e.) name formula nPages =get.document(50+0*now()) use this name on the cell you need to mention that figure (=npages) hth, hector. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to extract the number of pages in a cell (Excel 2003)
Hi guys,
Many thanks for your help. It works, you're great... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extract everything to the right in cell when a number is encounter | Excel Worksheet Functions | |||
| How to extract each digit from a number in one cell? | Excel Discussion (Misc queries) | |||
| how do i extract a number from a cell with no spaces? | Excel Worksheet Functions | |||
| Extract sheet name/number to cell | Excel Discussion (Misc queries) | |||
| Extract number in middle of cell | Excel Worksheet Functions | |||
Linear Mode
