Today, a guest appearance by Excel MVP Bob Umlas. Lets say that you have random chunks of Data and you need to add a Total to each chunk. In Episode #1832 Bob shows off a clever VBA solution that Adds the Totals in almost one line of VBA (Visual Basic for Applications) code. Also a reminder that Bob is the author of “Excel Outside the Box: Unbelievable Excel Techniques“.

Array

Excel Outside the Box: Unbelievable Excel Techniques” by Bob Umlas. Think that you know everything that there is to know about Microsoft Excel? Guess again. If you’re ready for the next level of Excel, then “Excel Outside the Box” is for you! ‘Outside the Box’ is an in-depth look at 54 amazing techniques from Excel MVP Bob Umlas. Have a look at the Table of Contents Here.