Thread: Footer code
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default 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.