Archive

Archive for the ‘Random’ Category

Triskaidekaphobia! Or in English: Microsoft Excel Team’s fear of 13.


So today when I saw something that look like this it made me smile:

Public Enum ExcelVersionEnum
    Excel4 = 4
    Excel95 = 7
    Excel97 = 8
    Excel2000 = 9
    Excelxp = 10
    Excel2003 = 11
    Excel2007 = 12
    Excel2010 = 14    'Triskaidekaphobia!
End Enum

There is no Excel version 13.  I of course only just found this out when I encountered Excel 2010 which, I blush to admit, I have not downloaded from TechNet yet and played with.

Triskaidekaphobia (from Greek tris meaning “3,” kai meaning “and,” and deka meaning “10”) is fear of the number 13; it is a superstition and related to a specific fear of Friday the 13th, called paraskevidekatriaphobia or friggatriskaidekaphobia.

Source : en.wikipedia.org/wiki/Triskaidekaphobia

Read more…

Excel VBA WTF 002


I have to say that poor old VBA and Excel gets blamed for a lot of things.   I guess its just easier for people who should never be allowed near a computer let alone develop on one to start messing about with it and produce something truly ghastly.

This story here is a great example of such evil being conducted in the good name of VBA.  ;P  THe DailyWTF is a great site and one of only 3 I can say I visit basically every working day for a quick check when I need a cheeky break.   Alex, if you are reading this I must get a sticker in snail mail soon.  I’ll collect up some stuff and send it over!

I must try to alternate these posts with something really positive or quirky that has been done in Excel VBA and has warmed a developers heart, or perhaps made the world a cooler place.

Categories: Excel oddities, Random, VBA, WTF

Really useful factoid – 001


Where I am developing at the moment an unusual little character is being used.  It’s this one  ‘¬’.  Its what you get with Shift+`  which for most (PC, non laptop I mean) keyboards is Shift+top left key on the keyboard.   When I first saw it I only had to have a 2 sec scan of my keyboard to work out how to type it myself.  I guess years and years in front of something quite limited will lead it to soaking in!

What I did find interesting is that Google and the other search engines tend to remove characters from their search terms or presume that you want to do an advanced search if you do use them, so I was out of luck to work out what the little blighter is called.  I know a ‘~’ is a tilde.  I don’t know where I knew that from either, so apart from looking like a bit of a loon and asking my whole team if they knew I resolved to work out how I could get to know, and then also all the weird other things that can be generated.

A few minutes went by and then it hit me… Read more…

Categories: Advanced, Factoid, Off Topic, Random, WTF

Found my first Googlewhack!


Awesome!   Its a bit sad, but after watching the DVD of Dave Gorman’s Googlewhack adventure I did struggle to find out how he found so many and the stories and people he met really struck a cord with me.

Dave Gorman's Googlewhack adventure

Dave Gorman's Googlewhack adventure

My Googlewhack?   ‘Argentine omniglossolalia’   it was used in an Independent article I was reading this morning as something made me take the free Independent paper that they are giving out until the conclusion of the UK Election.

I have yet to find out what omniglossolalia actually means which is how I stumbled across the Googlewhack itself.   Read more…