Footer code
 

http://www.bettersolutions.com/excel...D724516331.htm

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

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.

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.

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.

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

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

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