| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing data in footer in VBA
Thanks - exactly what was missing in my bag of tricks, thanks for helping
both the OP and ME TOO JMB!! "JMB" wrote in message ... It looks like you are trying to determine the number of printed pages. This may help. pgcnt = ExecuteExcel4Macro("Get.Document(50)") This is from: http://j-walk.com/ss/excel/tips/tip65.htm "William Benson" wrote: You have not assigned the PrintArea? Just a guess ... "Hans47" wrote in message ... Hi again William, Just another thing I tried.. the problem appears to be in the line calculating 'Pages' - it results in a zero which then causes the error. Hans -- Hans47 ------------------------------------------------------------------------ Hans47's Profile: http://www.excelforum.com/member.php...o&userid=17600 View this thread: http://www.excelforum.com/showthread...hreadid=384412 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| changing the size of the footer | Excel Discussion (Misc queries) | |||
| Changing date format in a footer | Excel Discussion (Misc queries) | |||
| changing footer before save | Excel Programming | |||
| Changing (Part of) Header Without Changing Footer or Rest of Header | Excel Programming | |||
| Landscape Orientation when Footer set using mso-footer-data Disappear | Excel Programming | |||
![William Benson[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
