Thanks Macropod
Another excellent document with clear explanations and examples. This will be as useful as your date calculations document.
Thanks Macropod
Another excellent document with clear explanations and examples. This will be as useful as your date calculations document.

This month, every Windows Secrets subscriber can download a one-chapter excerpt of Windows 7: The Missing Manual.Windows 7: The Missing Manual provides valuable information to help you overcome these difficulties in learning a new operating system. Subscribe today to download your free excerpt.
... and in your spare time? ...
Another great post. Thanks.
Hi macropod:
This is great. <img src=/S/bravo.gif border=0 alt=bravo width=16 height=30> Very well explained. Two suggestions:
1. p. 3 you left out a closing red bracket (you had "{=3+2" instead of "{=3+2}").
2. In the section on "Referencing Cells In A Table", you might point out that, although you can reference bookmarks in a table, those bookmark names should have at least 3 alpha characters if they end in a number. i.e. I used to name bookmarks bk1, bk2, etc. I learned the hard way that, in a table, you must use something like bmk1, bmk2. Word interprets bk1 as column bk, row 1.
Cheers,
Thanks Phil,
Updated to include both the correction and suggested comment re bookmarked tables. I've encountered that one on the odd occasion too, and it's not limited to purely alpha-numerics - other non-numeric characters followed by numbers sometimes get interpreted as cell references too.
Cheers
Cheers,
Paul Edstein
[MS MVP - Word]
> Feedback welcome,
That is truly awesome, thank you.
StuartR
In one word: Wow!
It seems wonderfully crafted. I hope I'll get round to having a more detailed look at it.
Keep it up!! <img src=/S/thumbup.gif border=0 alt=thumbup width=15 height=15>
<img src=/w3timages/blue3line.gif width=33% height=2>
<img src=/S/flags/Argentina.gif border=0 alt=Argentina width=30 height=18> <big><font color=4682b4><font face="Comic Sans MS">Diegol</font face=comic></font color=4682b4> </big>
Many thanks Macropod. This appears to contain some very clever stuff.
Alan
Wow, thanks this looks good and will be helpful. Thanks
Hi macropod,
I'm confused. It appears in looking at the current version of your post that you were posting V1.02. I checked my archives and found there was a V1.02 last spring (April or so). The description of what's covered seems to be the same. The file size is the same. Is this a posting of a new V1.03 or V1.02+?
I know you can edit your old post and change the text and the attachment. Even tho it's a convenience for you, I find it confusing for my old feeble mind <img src=/S/grin.gif border=0 alt=grin width=15 height=15> to keep up what's new or not.
But new or not, it's certainly a great piece of work.
Thanks.
Fred
Sorry about the confusion. Macropod is innocent. This weekend, we found out that macropod's post had never been awarded the star it deserved, although it was almost a year old. It was starred, and to get it listed in the StarPost banner, its date was updated (the StarPost banner always lists the most recent star post.) The contents of the post and its attachment are unchanged.
And a well deserved star at that, even if it's a little late.
Fred
I've just read the post now, and also want to compliment you on some awesome info. This is definetly a post i will visit from time to time to collect some useful calculation strategies.
Cheers
Regards,
Rudi
All's well that ends with an answer in WOPR!
Wow, absolutly great for reference. Something I will keep and use many times in future. Thank you for an outstanding post.
Carla
Can't wait to dig into the latest book of spells and hexes! <img src=/S/grin.gif border=0 alt=grin width=15 height=15> I'm just wondering if it would be possible/ easy to highlight <img src=/S/new.gif border=0 alt=new width=35 height=15> features in the contents description, as each new and exciting installment comes to our screens? Either way, many thanks for your continuing unique insights.
Alan