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 |