A nice quick tip, I had lots of cell values in a mixture of cases that should have been uppercase.
Create a macro:
sub MakeUpper()
for each myCell in Selection
myCell.Value = UCase(myCell.value)
next myCell
end sub
Add a menu item to your toolbar and then assign this macro to it.
Select the cells you want to upper case then press the button!
OK it’s been a week since I finished my second marathon:
This was the first “big” race in my year long 1,000km in 2011 for Marie Curie.
To just add an extra element to the marathon my friend Andy from Reynard Nursery asked me to tweet every mile. I knew every mile would be very offputtingbut I thought I would give it a go. My marathon day tweets start here. I had experimented with VLingo for my BlackBerry which I was carrying anyway. My pre race day tests were all fine – press a button – speak – translated into text – press a button to confirm sending it to Twitter – easy. On the day, being a little breathless and having a howling gale (more of that later) things didn’t go quite to plan. “Four Miles” was translated as “F******* Hell” and “Five Miles and Feeling Good” was translated as “Hi Smiles and Feeling Good”. I reverted to typing after that.
As you should know by now I’m running the Edinburgh Marathon to raise funds for Marie Curie Cancer Care. This event is part of my challenge of running 1,000km in 2011. Every £20 raised for Marie Curie helps provide one hour of nursing care. Marie Curie were a fantastic help with my daughter Emma before we lost her to MND.
If you are feeling generous I will be accepting donations until the end of the year at http://www.justgiving.com/1000k-in-2011
If you would like to follow me during my marathon I have set up my phone so you can track my progress:
Another way you can track my progress is via Twitter: https://twitter.com/rossgoodman
I will be attempting to live tweet during the run using VLingo on my phone which should tweet whatever I speak to it. Who knows how well it will work when I’m a bit “breathless”.
Sometimes you find a feature in a product that is just blatantly missing. One of those in Microsoft Word is the ability to update all the fields in the document with the latest value in a field.
I use both the built in fields e.g. Author, Version, Title and custom fields e.g. Project Code. I set the values once in the document properties and then insert the field codes in the document rather than the text. All is well. If you change the value of a field you can press F9 and all of the fields update to the latest value EXCEPT if you have used the fields in the document header or footer, these do not get updated for some reason. I would classify this as a bug, why would I not want all instances of the same field to be in sync throughout my document.
The solution is remarkably simple. Create the following macro:
Sub UpdateAll()
Dim oStory As Range
Dim oField As Field
For Each oStory In ActiveDocument.StoryRanges
For Each oField In oStory.Fields
oField.Update
Next oField
Next oStory
End Sub
This can be saved in your normal.dot file and will be available in all your word documents.
Today the Scottish government, police, SFA and the old firm are having a summit to address the problems following last weeks match.
The problem is, the football clubs are a business and unless everyone is involved, shareholders included, then this will go nowhere. There is also the problem as to how to make this fair and equitable for smaller clubs as well as the very top tier.
My Solution:
The Players
Any player recieves a yellow card they forfeit 1 weeks pay.
A red card – forfeit two weeks pay.
i.e. two yellows and a red is four weeks pay forfeited.
Even if a player recieves a red and then continues to protest the ref can issue another yellow or red as he sees fit.
The Management
The referee or another official has the ability to issue yellow and red cards to the touchline management staff with the same forfeit as above.
Now the management will loose their pay if their behaviour is not up to scratch.
The Team
A yellow card equates to one point, a red gives two points. If a team (players and management) accrue over 5 points in a single game, they forfeit their share of the gate money for the match. If the team accrue over 8 points in a single match they loose all income from the match gate, TV, food etc.
Who Benefits
The teams do not get to choose, the SFA or public can choose a charity every week or month and all fines get paid to them. This way the team is still out of pocket as they have to pay the player’s wage even though the player will not recieve it.
Lets see how long it takes for the teams to get their act together and play in a responsibe, respectful and sportsman like manner.
As you may knowI am planning to run 1000km in 2011 to raise funds for Marie Curie Cancer Care.
To date I have run 164km or 16.4% of my target distance – unfortunately I am only at 4% of my fundraising target – Never mind I have the Meadows (half) marathon, the Kilomathon and the Edinburgh Marathon in the next few months to give the fundraising a boost.
I thought it would be fun to visualise just how far 164km is, turns out I would be almost at Newcastle by now!
You can see this by clicking here.
I have been reading a few articles recently on e-mail etiquette and thought that it was about time I described how I use e-mail.
You can read the concept behind this here.
My inbox is normally empty. If you have sent me an e-mail and then pop over for a chat to chase me up and donât see the mail in my inbox, donât panic, if itâs not in my inbox it means that it has been filed, if required it will be on my To-Do list (http://www.RememberTheMilk.com) or will have an Outlook reminder tagged on it.
Yes I do have two separate systems, this is due to client confidentiality issues. I use a single system where possible.
Conversely, if you see my inbox is full, donât panic, it just means that Iâm busy working and have decided to not process my inbox at the moment, Iâll get to it when I have some more bandwidth.
As alluded to above, I donât slavishly watch my inbox, I deliberately ignore it at times. If Iâm really busy Iâll even close Outlook/GMail/Pidgin/Blackberry to ensure that Iâm not disturbed. If something is urgent and I havenât responded, IM me, or call me or come and see me. (I may tell you that I canât respond at the moment, but at least you will know Iâm alive!)
I have some colleagues that use out of office responses when they are âbusyâ?. I donât like this as it just adds to the ânoiseâ?. I may however book a meeting with myself to block out my calendar to prevent meeting requests when Iâm working to a deadline.
To make e-mail work best:
If you must, feel free to send me a âThanksâ? e-mail but it is not expected, I only send these occasionally, again to cut down on the ânoiseâ?. I canât think of the last time I sent a âYour Welcomeâ? e-mail, although I do really appreciate you all!
As you know I have pledged to run 1,000 kilometers in 2011 For Marie Curie Cancer Care.
Here is the first draft of the dashboard I’ll be using to communicate my progress.
Click here for the bigger version.
The JustGiving page has also been set up here : http://www.justgiving.com/1000k-in-2011
In 2011 I plan to run 1000km to raise funds for Marie Curie Cancer Care.
This will be spread across multiple events including the Edinburgh Marathon and all of my training sessions.
If you would like to donate please visit http://www.justgiving.com/1000k-in-2011
photo credit: Nick-K (Nikos Koutoulas)
The concept behind Marcothon was simple : run every day in December for at least 25 minutes or 3 miles.
My results:
Officially that is a “fail” but it is my fourth best month in the year for distance and time but by far my best for actual number of runs.
I’m counting it as a HUGE success as it has been the ideal “warm up” for my 2011 running challenge.