If I choose Show -> Header and Footer and then I personalize the right footer with this code:
I get: 1 of 15&[Page] of &[Page]+5
Ok, I know should be using &[Page] of &[Pages]
But I am curious. Is that a bug???
If I choose Show -> Header and Footer and then I personalize the right footer with this code:
I get: 1 of 15&[Page] of &[Page]+5
Ok, I know should be using &[Page] of &[Pages]
But I am curious. Is that a bug???
Best Regards,
Carlos Paleo.
To every problem there is a solution, even if I dont know it, so this posting is provided "AS IS" with no warranties.
If Debugging is harder than writing a program and your code is as good as you can possibly make
it, then by definition you're not smart enough to debug it.
http://www.mugrs.org
By the way,
if I put &[Page] of &[Pages]+5 I still get the same result "1 of 15", no matter how many pages does the plan have.
Best Regards,
Carlos Paleo.
To every problem there is a solution, even if I dont know it, so this posting is provided "AS IS" with no warranties.
If Debugging is harder than writing a program and your code is as good as you can possibly make
it, then by definition you're not smart enough to debug it.
http://www.mugrs.org
Hi Paleo,
I copied and pasted your setting into Excel2000 and it came up with 1 of 6, 2 of 7, 3 of 8 etc.
With [Pages]+5 I get 1 of 11 ... 6 of 11
MD
Originally Posted by Paleo
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
By the way 2,
if I put a single space after the "+5" it works fine.
Any idea?
Best Regards,
Carlos Paleo.
To every problem there is a solution, even if I dont know it, so this posting is provided "AS IS" with no warranties.
If Debugging is harder than writing a program and your code is as good as you can possibly make
it, then by definition you're not smart enough to debug it.
http://www.mugrs.org
Hi mdmackillop,
thats even stranger, because in excel XP and 2003 the problem I have described happens. Tested English and Portuguese Brazilian versions. Problem on both.
Best Regards,
Carlos Paleo.
To every problem there is a solution, even if I dont know it, so this posting is provided "AS IS" with no warranties.
If Debugging is harder than writing a program and your code is as good as you can possibly make
it, then by definition you're not smart enough to debug it.
http://www.mugrs.org
It also does work for me in xl2000 (English). It looks to me like your original line is treating the + as a concatenation operator ("1 of 1" & 5 = "1 of 15"). No idea why its doing this to you!
Hi mvidas,
Yes, exactly. It is treating the "+" as a concatenation operator. Even if you type "1+2" it does not sum them, simply consider then as a string, but if you add a single space after then like "1+2 ". Voilla, it works fine. Any reason for that other than a bug?
Last edited by Paleo; 01-24-2005 at 12:18 PM. Reason: Completing
Best Regards,
Carlos Paleo.
To every problem there is a solution, even if I dont know it, so this posting is provided "AS IS" with no warranties.
If Debugging is harder than writing a program and your code is as good as you can possibly make
it, then by definition you're not smart enough to debug it.
http://www.mugrs.org
Hi Paleo,
No problem in my Excel2003 either. Out of interest, here's a zip file which is OK with me, how does it show with you?
MD
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Gee, now its worse. Now I must think it has something to do with regional settings. Can it?
Best Regards,
Carlos Paleo.
To every problem there is a solution, even if I dont know it, so this posting is provided "AS IS" with no warranties.
If Debugging is harder than writing a program and your code is as good as you can possibly make
it, then by definition you're not smart enough to debug it.
http://www.mugrs.org