| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Footer code
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Footer code
Sorry that I forgot to type my q
I tried &P+10 but failed to get the expected result e.g. if current page is 1 then I get 110 instead of 10 Is it the expected result? Thanks. equiangular wrote: http://www.bettersolutions.com/excel...D724516331.htm |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Footer code
What code are you using? This works for me:
ActiveSheet.PageSetup.LeftFooter = "&P+10" Though the first page displays a page number of 11, not 10. In article , equiangular wrote: Sorry that I forgot to type my q I tried &P+10 but failed to get the expected result e.g. if current page is 1 then I get 110 instead of 10 Is it the expected result? Thanks. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Footer code
I'm using ExcelXP
I tried both setting in page setup dialog an through VBA. I got 20 for the first page and 30 for the second page. JE McGimpsey wrote: What code are you using? This works for me: ActiveSheet.PageSetup.LeftFooter = "&P+10" Though the first page displays a page number of 11, not 10. In article , equiangular wrote: Sorry that I forgot to type my q I tried &P+10 but failed to get the expected result e.g. if current page is 1 then I get 110 instead of 10 Is it the expected result? Thanks. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Footer code
Try to add a space after the 10
See this KB http://support.microsoft.com/kb/48198/en-us -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "equiangular" wrote in message ... I'm using ExcelXP I tried both setting in page setup dialog an through VBA. I got 20 for the first page and 30 for the second page. JE McGimpsey wrote: What code are you using? This works for me: ActiveSheet.PageSetup.LeftFooter = "&P+10" Though the first page displays a page number of 11, not 10. In article , equiangular wrote: Sorry that I forgot to type my q I tried &P+10 but failed to get the expected result e.g. if current page is 1 then I get 110 instead of 10 Is it the expected result? Thanks. |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Footer code
Thanks, Ron - I forgot when I tested it that it only works correctly in
MacXL. In article , "Ron de Bruin" wrote: Try to add a space after the 10 See this KB http://support.microsoft.com/kb/48198/en-us |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Footer code
Hi JE
that it only works correctly I also want a MAC <g -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "JE McGimpsey" wrote in message ... Thanks, Ron - I forgot when I tested it that it only works correctly in MacXL. In article , "Ron de Bruin" wrote: Try to add a space after the 10 See this KB http://support.microsoft.com/kb/48198/en-us |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Footer code
It's so tricky
Thanks all! Ron de Bruin wrote: Try to add a space after the 10 See this KB http://support.microsoft.com/kb/48198/en-us |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need help with a Macro or VB code for Header/Footer | Excel Programming | |||
| How do I code authorship into a footer? | Excel Discussion (Misc queries) | |||
| add a footer to excel through VB code | Excel Programming | |||
| Formatting footer in VBA code | Excel Discussion (Misc queries) | |||
| Code for Page Footer Font Size | Excel Programming | |||
Linear Mode
