Excel Formula, Charts, Macro, VBA and Tips

Prevent Users Ctrl Break (ing) Your VBA Code During Execution

Anytime I write VBA code that runs for more than a split second, one of my worries remains that someone will ctrl + break it. You see, I am a very strong supporter of P.E.T.A. (People for Ethical Treatment of Algorithms) and believe that any code, no matter how long it takes (or in my case how badly written it is), must be allowed the dignity to complete. And for those who believe in killing ...

Cricketing Heat Map

Posted on 22 February 2010

Heat maps are pretty versatile. They have been used for everything ranging from charting home prices to changes in the stock market. (Average Listing Price for US states, week ending Feb 17, 2010. Source : www.trulia.com) (SNP performance, Feb 19, 2010. Source : www.finviz.com/map.ashx) Inspired by the last ball win over the South Africans yesterday night, I wondered if some of that action could be captured in ...

Comments (5)

Opera Anyone ?

Posted on 10 February 2010

Looks like I am not the only one suffering from browse fatigue. Excel guru Dick Kusleika recently made the shift from Firefox to Chrome and he wasn't very impressed. I myself have been fiddling around with various browsers lately. Right before my earlier computer gave up the ghost and I shifted on to the new one, I had been hell bent on squeezing out the last remaining ounce ...

Comments (18)

Multiple Scale Chart – Adding Customized Scale to Each Category in a Chart

Posted on 03 February 2010

So how do you fit multiple scales on a single excel chart? No, we are not referring about the primary and secondary scales on an Excel chart here, we are talking about adding a customized scale for each category in the chart. Take for example the receipts portion of the U.S. federal budget - a data set with multiple categories such as individual income, social security, excise, estate and other taxes & duties. ...

Comments (10)

The Content Aggregator Called Excel

Posted on 31 January 2010

So you have been toiling away on a spreadsheet that must reach the CEO's desk before the end of the day. Your boss has been after your life to get this done as fast as possible with his frantic phone calls and a rather sharp pitchfork that he uses on special occasions like these. A gazillion formulas, allocations and calculations later, with your body screaming for some coffee, you allow yourself a break. As you return to your desk with ...

Comments (4)

Table Formula in Excel (Something I didn’t Know Till Yesterday)

Posted on 28 January 2010

Table formulas were something that I discovered recently. Actually our reader m-b commented that he prefers to convert a range to a table and then employ table formulas instead of named ranges. That got me curious enough to explore them further and here's what I learnt. A Table in Excel A table is a feature in Excel that makes it easier to format and analyze a set of data points in a spreadsheet. Tables were introduced in Excel 2007 as an ...

Comments (24)

Multithreaded VBA – An Approach To Processing Using VBScript

Posted on 25 January 2010

Today's guest post is authored by Daniel Ferry, a longtime professional Excel developer and consultant (and a newbie blogger). A few months ago, I wrote a post on how one can simulate multithreading in VBA using Excel. Daniel picked up a thread from there and commented that he had some good success in marshalling some of windows multithreaded subsystems from within VBA. In this article he describes his approach. Multithreading VBA - Using VBScript Try as we might to work around ...

Comments (10)