| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert total of page in a worksheet in a cell
Hi,
In Excel 2003, do you know how I can insert in a cell the totals pages (only print page) that I have in the worksheet. I don't want to use the header and footer function. Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Insert total of page in a worksheet in a cell
Sub Test()
Dim TotPages As Long TotPages = Application.ExecuteExcel4Macro("GET.DOCUMENT(50)") ActiveSheet.Range("A1").Value = TotPages End Sub Gord Dibben MS Excel MVP On Tue, 18 Aug 2009 09:51:01 -0700, catherine wrote: Hi, In Excel 2003, do you know how I can insert in a cell the totals pages (only print page) that I have in the worksheet. I don't want to use the header and footer function. Thanks |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Insert total of page in a worksheet in a cell
Thanks, it's working
"Gord Dibben" wrote: Sub Test() Dim TotPages As Long TotPages = Application.ExecuteExcel4Macro("GET.DOCUMENT(50)") ActiveSheet.Range("A1").Value = TotPages End Sub Gord Dibben MS Excel MVP On Tue, 18 Aug 2009 09:51:01 -0700, catherine wrote: Hi, In Excel 2003, do you know how I can insert in a cell the totals pages (only print page) that I have in the worksheet. I don't want to use the header and footer function. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I insert and resize a column on only one worksheet page? | Excel Discussion (Misc queries) | |||
| How to insert web page content into excel worksheet? | Excel Discussion (Misc queries) | |||
| Need page number & total pages in worksheet - not header or footer | Excel Worksheet Functions | |||
| How do I insert a Sub total at every page break? | Excel Discussion (Misc queries) | |||
| Insert Page Break in the Worksheet | Excel Programming | |||
Hybrid Mode
