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

March 2009 - Daily Dose of Excel

Sort by: Most Recent | Most Viewed | Most Commented

  • Elle’s Birthday

    Yesterday was Elle MacPhereson’s birthday. Oh, yeah, it was Daily Dose of Excel’s birthday too. Can you believe it’s been five years? Feels like 20. Checking the archives, I see that my first post was SUMIF Between Two Dates. I guess that was a pretty good one to start with, since it’s [...] Read More...
    Filed under:

  • A Little Companionship

    From A Young Professionals Blog You might think I’m pathetic. Well, you’d be right. What is the corporate world coming to when a sophisticated collection of zeros and ones is elevated to the level of a friend? But you know what? It’s reality. We spend SO much time in front of spreadsheets we might as well [...] Read More...
    Filed under:

  • Bumping Email

    Sometimes I will send an email to someone requesting some information or suggesting some action. Sometimes, they ignore me. Can you believe that? In those cases, I need to resend the message, but with a new, strongly-worded message at the top. Under the Actions menu, there is a Resend This Message button, which [...] Read More...
    Filed under:

  • Galleries in the Ribbon

    Hi all This week I create a new page about Galleries on my site. http://www.rondebruin.nl/galleries.htm I not say it is good but it is a good start. It was the first time I really work with Galleries so if you have suggestions please let me know. Thanks Ron de Bruin http://www.rondebruin.nl/tips.htm Read More...
    Filed under:

  • Out of Rows

    The Website Is Down: Excel Hell Video NSFW for language (so plug in your headphones). Read More...
    Filed under:

  • Euler Problem 104

    Euler Problem 104 asks: The Fibonacci sequence is defined by the recurrence relation: F(n) = F(n-1) + F(n-2), where F(1) = 1 and F(2) = 1. It turns out that F(541), which contains 113 digits, is the first Fibonacci number for which the last nine digits are 1-9 pandigital (contain all the digits 1 to 9, [...] Read More...
    Filed under:

  • Outlook Default Folders

    In Outlook, I want to delete a folder if it has nothing in it. I don't want to delete the built-in folders like Inbox, Outbox, Junk, etc., mostly because I get an error if I try. I couldn't find a property of the MAPIFolder object that told me if it was a default [...] Read More...
    Filed under:

  • Excel multi-threading calculations on 8 processors

    Ever wondered what it means to have Excel multi-thread its calculations? On a 64bit I7 computer, crunching 500,000 rows of calculations for the Euler 36 problem resulted in the below. The display was from the 64bit version of the Process Explorer program (www.sysinternals.com though now a part of Microsoft at http://technet.microsoft.com/en-us/sysinternals/default.aspx). HTML clipboard Read More...
    Filed under: , ,

  • Graphics I Grok

    As a big-time college basketball junkie (Villanova ‘96 grad school–Kerry Kittles et al), I thought the NY Times had two excellent NCAA basketball tourney graphics. No pie charts! I needed a tech assist from Dick to learn how to do this, so I’m not as timely as I should have been, and that [...] Read More...
    Filed under: ,

  • Euler Problem 62

    Euler Problem 62 asks: The cube, 41063625 (345^3), can be permuted to produce two other cubes: 56623104 (384^3) and 66430125 (405^3). In fact, 41063625 is the smallest cube which has exactly three permutations of its digits which are also cube. Find the smallest cube for which exactly five permutations of its digits are cube. Having discovered how to [...] Read More...
    Filed under:

  • Bingo

    Deb created some bingo cards in Excel and issued a challenge to come up with a number selector. Here's mine. When I recorded this video, I didn't know that the only certain numbers could go with certain letters. I've changed the workbook to accommodate that rule, but I don't feel like re-recording, [...] Read More...
    Filed under:

  • Looping Through Sheets

    There are a number of ways to loop through the sheets in the workbook. Here are three examples. In the first example, I create an Object variable and use the For Each construct. As you know, Sheets can be Worksheets, Chart Sheets and Dialog Sheets. They can also be Macro sheets, but those [...] Read More...

  • Code Construction

    Everyone has their unique ways of coding in VBA. I know I do and someday I'm going to write them all down. I'm changing my method for a couple of things. First, I'm going to follow Bob's advice and put all my error-on-purpose code in a separate procedure. So instead of [...] Read More...
    Filed under:

  • VBA Here to Stay

    Clarification on VBA Support In case you missed it: We understand that VBA is a critical capability for large numbers of our customers; accordingly, there is no plan to remove VBA from future versions of Excel. And if you want to read some 2.5 year old predictions about VBA, go revisit The Future of VBA Read More...
    Filed under:

  • Update VBA code page for Tables and Create/Mail PDF files

    Hi all I update two pages for Excel 2007 on my website. Create and mail PDF files with Excel 2007 http://www.rondebruin.nl/pdf.htm VBA code examples for Tables in Excel 2007 or a List in Excel 2003 http://www.rondebruin.nl/tablecode.htm Maybe useful for the readeres of the blog If you have Suggestions or find bugs let me know Thanks Ron de Bruin http://www.rondebruin.nl/tips.htm Read More...
    Filed under: ,
1 2 Next >
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.