Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

August 2011 - Daily Dose of Excel

Sort by: Most Recent | Most Viewed | Most Commented

  • Same function different add-ins

    Ever since Microsoft introduced the ribbon and I did my initial development work with it, an open issue has been how to handle the case where two, or more, add-ins offer the same functionality. One scenario is when the feature is something required for the larger functionality offered by an add-in. Here’s an [...] Read More...

  • Excel 2011 on the Mac

    Hi all FYI A few weeks back I start working on my first Mac, and I must say I love the OS but there is a lot of work to do in Office for the Mac. My idea is to go through all my webpages and see if I can make the VBA code also working in Excel [...] Read More...
    Filed under:

  • Ease of reuse of modular code

    The primary reason I write modular code is that it is self-documenting, easy to understand, and easy to maintain. A secondary reason is the ease of reuse. One of the comments to my post Two new range functions: Union and Subtract (www.dailydoseofexcel.com/archives/2007/08/17/two-new-range-functions-union-and-subtract/) was a request for code to copy a range from one worksheet to [...] Read More...
    Filed under: , ,

  • Andrew’s Excel Tips Moved

    Andrew’s Excel Tips has a new home Why the change? Well, my old blog site was getting very tired. Comments were disabled due to the inability to fight spam effectively and I missed getting feedback. People don’t move their blog unless they have some good stuff coming up. Update your RSS reader and don’t miss it! Read More...
    Filed under:

  • Save a global variable in an Excel workbook

    Developers who have done any kind of programming with the Office 2007 (and later) Ribbon architecture have encountered almost certainly a scenario that resulted in the loss of their pointer to the ribbon. This happens because the ribbon object has to be stored in a global variable and any kind of unhandled error leads [...] Read More...

  • Office 2010 VBA

    Microsoft made several changes to VBA in Office 2010, all of them targeted at the one major change in the Office 2010 architecture, i.e., the availability of 64-bit Office applications. This note summarizes how the changes affect developers. I imagine there is a comprehensive list somewhere in the microsoft.com universe but I could [...] Read More...
    Filed under: , ,

  • Pimping the Bootcamp

    There’s an Excel Power Analyst Bootcamp in our nation’s capital next month. Well not our nation’s capital, but mine. OK, it’s Washington DC. More like Alexandria, VA. Or it might be Springfield, VA. Just ask the cabbie to take you to the Sheraton in old town Alexandria. He’ll know [...] Read More...
    Filed under:

  • Overlapping Dates

    Given a Bill Date and a Cycle Days, Kimberly wants to determine how many days in the cycle fall in Winter. For our purposes, Winter is defined as November 1st to April 30th. I put the season start dates in D1 and D2 and use this formula to find the difference. =MIN(C5,B5-IF(B5>$D$2,DATE(YEAR(B5),MONTH($D$2),DAY($D$2)),IF(B5>$D$1,DATE(YEAR(B5),MONTH($D$1),DAY($D$1)),DATE(YEAR(B5)-1,MONTH($D$2),DAY($D$2))))) It’s not as [...] Read More...
    Filed under:

  • Highlight matches to the current cell

    I came across a very reasonable request from someone who wanted to see which entries in a list matched those in the current cell (http://answers.microsoft.com/en-us/office/forum/office_2010-excel/event/49aa9987-3cf5-4007-9f08-df076ff0beba). While the original request dealt with names, I abstracted the problem into a set of numbers. Column A in Figure 1 is one list of numbers. Column [...] Read More...
    Filed under:

  • CELL Worksheet Function

    I learned something today. I “knew” that omitting the optional reference argument from the CELL worksheet function meant that the cell that contained the worksheet function was used. Patrick McDonald correctly pointed out that it uses the last changed cell, not the host cell. In a new worksheet, type =CELL("width") in cell B3. [...] Read More...
    Filed under:
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.