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

May 2010 - Daily Dose of Excel

Sort by: Most Recent | Most Viewed | Most Commented

  • Calendar Control DLL on Windows 7 64 Bit

    I got a message like “MISSING: Microsoft Windows Common Controls 2.6.0″ and I’m using 64bit Windows 7. Here are the steps I had to take to fix: Download the cab files from this knowledgebase article. Right click on the CAB file and choose 7-zip - Extract to \mscomct2\ Open that folder and copy the two files (.ocx [...] Read More...
    Filed under:

  • Comparing Two Lists

    I want to describe for you a process that I do many times every month. Then I’m going to tell you how I tried, and failed, to make it easier. Put on your seat belts, here we go. I repeatedly have situations where I have two CSV files containing lists. Each list has [...] Read More...
    Filed under: ,

  • Excel control idMso’s of Excel 2010

    Hi all Maybe a useful file if you want to change the Excel 2010 Ribbon? I add a file to my site with all Excel control idMso’s of Excel 2010 RTM I add a Advancedfilter to the MS file so it will filter on groups and display a picture of the group. http://www.rondebruin.nl/files/RDB_Built-in_idMso’s_Excel_2010.zip You can also find the download link [...] Read More...
    Filed under:

  • Omaha CPA Who Knows Excel

    I was reading Gobán Saor’s essay about learning software: At a minimum, everybody should be taught the basics and the possibilities of spreadsheets. At a minimum, I thought, accounting degrees should have a class dedicated to spreadsheets. And who better to teach it than me? What if my Alma mater decides to create such a [...] Read More...
    Filed under:

  • Performance of linked pictures

    I frequently use the camera tool to create pictures linked to cell ranges. For example to be able to have different column widths beneath each other on one sheet. They have one major drawback however: they can slowdown VBA performance (when updating cells) enormously (update time may go up from .2 secs to as much as 8 [...] Read More...
    Filed under: , ,

  • Find and Replace Hyperlinks

    Sub FindReplaceHLinks(sFind As String, sReplace As String, _     Optional lStart As Long = 1, Optional lCount As Long = -1)         Dim rCell As Range     Dim hl As Hyperlink         For Each rCell In ActiveSheet.UsedRange.Cells         If rCell.Hyperlinks.Count > 0 Then             For [...] Read More...
    Filed under: ,

  • GoodTodo

    I’ve been using the Getting Things Done and 43 Folders method to organize my life for a almost a decade now. It’s definitely a system that works for me. I’ve tried in the past to rid myself of the paper aspect of this method and make it electronic without success. A few [...] Read More...
    Filed under:

  • Creating Dynamic Named Ranges in VBA II

    I recently posted about Creating Dynamic Names in VBA where created a bunch of names that would expand with the data provided. I created names that look like =Sheet1!$C$2:INDEX(Sheet1!$C:$C,COUNTA(Sheet1!$A:$A)) I like Tushar’s idea so much that I deleted all my names and redid them using Offset (except column A of course). Tushar commented that I [...] Read More...
    Filed under: ,

  • Logic Problem Grid

    My wife brought home a book of logic problems recently. It’s been years since I did one of these puzzles, but I think they’re fun. These are the kind where you set up a grid, like this Then you get a series of clues to help you identify matches. The puzzle part is [...] 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.