Archive

Archive for May, 2010

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