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

January 2009 - Daily Dose of Excel

Sort by: Most Recent | Most Viewed | Most Commented

  • Looping Through Months

    Given two dates, I'd like to loop through the months. If my start date is 1-Oct-2007 and my end date is 30-Sep-2008, then I'd like my loop counter to be 10,11,12,1,2,3,4,5,6,7,8,9 as it loops through the dates. It might look like this: Sub LoopMonths()         For Month = dtStartDate To dtEndDate         [...] Read More...
    Filed under:

  • New Project Workbook

    I use a New Project workbook whenever I'm starting, wait for it, a new project. The idea is that I always have the same stuff in my projects, so why set it up from scratch. At first, it contained the minimum stuff - stuff that was guaranteed to be in every project. [...] Read More...

  • Useful addition to Outlook 2007

    Hi all A common question in the newsgroups is this: How do I send an e-mail with VBA code from another account then the default account? In Office 2007 we can use SendUsingAccount now to change the account in Outlook. I create a small example page yesterday with a example. http://www.rondebruin.nl/mail/account.htm Let me know if it is working for you. Thanks Ron de [...] Read More...
    Filed under:

  • Finding Stray Text

    I have a range that should only contain numbers. Blanks are OK, but I need to determine if anyone "deleted" a cell by typing a space or entered text in any other way. This worksheet formula returns TRUE if there is text in the range: =COUNTA(A1:C6)-COUNT(A1:C6)>0 COUNTA counts all the non-blank cells while COUNT counts [...] Read More...

  • A Fresh Start

    From 8:30 AM until 7:30 PM on Saturday, I listened to about 200 songs on my iPod and played about 50 games of spider solitaire. You see, I had the pleasure of reformatting my hard drive and reinstalling all of my favorite applications. I like to reformat my hard drive every couple of [...] Read More...
    Filed under:

  • Euler Problem 54

    Euler Problem 54 asks: 'In the card game poker, a hand consists of five cards and are ranked, 'from lowest to highest, in the following way: ' '    * High Card: Highest value card. '    * One Pair: Two cards of the same value. '    * Two Pairs: Two different pairs. '    * Three of a Kind: Three [...] Read More...
    Filed under:

  • List of Office Developers

    One of the first questions on the Buyer’s Guide is How do I find an Excel developer?. I’d like to create a list of Office developers. If you were going to create such a list, what would you include for information and who would you exclude from the list. I’m thinking Name | Office [...] Read More...
    Filed under:

  • Wordpress Upgrade

    My Wordpress install was just upgraded, so things might be screwy while I get things sorted. I’m trying out a live preview plugin on the comments. Read More...
    Filed under:

  • Euler Problem 43

    Euler Problem 43 asks: 'The number, 1406357289, is a 0 to 9 pandigital number because it 'is made up of each of the digits 0 to 9 in some order, but it also 'has a rather interesting sub-string divisibility property. ' 'Let d_(1) be the 1st digit, d_(2) be the 2nd digit, and so on. 'In this way, we note the [...] Read More...
    Filed under:

  • Project Euler questions and Excel solutions

    For those who might be curious about the relevance of Excel to Project Euler problems, I am categorizing my solutions. Of the 36 that I have solved, 19 were with Excel or by hand, though some I also solved with VBA. 3 problems were solved using Excel with the UDFs from the Large Number Arithmetic [...] Read More...
    Filed under:

  • Excel Consulting Buyer’s Guide

    I’m ramping up my Excel consulting business. In these times of woe and want, it’s nice to have a backup plan. I’d like to have a web page where potential clients can read about Excel consulting in general, and not necessarily a sales pitch for a particular consultant. The purpose will be [...] Read More...
    Filed under:

  • Office14 Sneak Peek

    UX Evnagelist via Harlan’s Smurf Comment Read More...
    Filed under:

  • How to Learn Excel

    Karen asks: “How do I become an excel/access master?” Good question. As I was composing my reply, I realized that your comments will dwarf my response and that the only place for a question like this is on a blog. The only way to get good is to solve real-life problems. The best way to [...] Read More...
    Filed under:

  • Dynamic Favorites

    I have a favorites add-in that I use every day. There’s always a couple of frequently used files that I can’t add to my favorites menu because they change periodically. One example is my inventory reconciliation file. I have several such files in a folder and they are named InvRecon20081130.xls and InvRecon20081231.xls. I [...] Read More...
    Filed under:

  • Large Number Arithmetic

    One of the incentives to tackle the Project Euler problems has been the opportunity to build a library of functions usable outside of the PE questions themselves. The first few functions tackle basic arithmetic for numbers that neither Excel nor VBA support natively. In Excel the limit is 15 digits and in VBA the Decimal [...] 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.