Category: Excel

Excel by FinancialRadDeveloper

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

Continue reading Triskaidekaphobia! Or in English: Microsoft Excel Team’s fear of 13.
VBA by FinancialRadDeveloper

Excel VBA Interview Questions (aka Things every *good* Excel VBA developer should know)


I thought that I would compile a list of things that *I* think every good Excel developer should know.   I don’t mean techniques in particular, just things that people who work with Excel VBA intensely each day should know.

Edit: I think a lot of people will be searching for Excel VBA Interview questions and answers so I have renamed the post and changed the format slightly.  I will include all the answers on a separate post so people can try these for themselves and use it to check, or just go there immediately and cheat ;-P

I’ll illustrate :   Alt+F11.  If you don’t use this, or don’t know when asked what it does, I would say you know Jack about VBA.    This is only my own opinion, but a lot of these things do come up as interview questions as they are quite esoteric and won’t really be something a pretender would, or come to think about it, could Google for when cramming for the interview.

I’ll start simple and group things up so they should all make sense.

Excel Interview Questions

Easy

  • What does Shift+D do in this case?
  • What does Ctrl+D do in this case?

  • What will happen if I pull down on the corner using the plus symbol making the 1×3 cell deep selection grow to 1×10?
Continue reading Excel VBA Interview Questions (aka Things every *good* Excel VBA developer should know)