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

July 2009 - Daily Dose of Excel

Sort by: Most Recent | Most Viewed | Most Commented

  • Navigating Protected Sheets

    In Excel 2003, I was happily moving from sheet to sheet using Control+Page Up/Page Down. Suddenly it stopped working. Instead of moving to the next sheet, I was scrolling one page to the left/right with those key combinations. I couldn't get off of this particular tab without clicking on another one with [...] Read More...
    Filed under:

  • Outlook Mail Worksheet Template for Excel 2007-2010

    Hi all I have create a new worksheet template for Excel/Outlook 2007-2010 for mailing this week. (with great suggestions from Dave Peterson) You can download it here http://www.rondebruin.nl/mail/outlooksheettemplate.htm I think on this moment it have a lot of mail options that are very easy to change/use. You can mail one or many custom mails with one click of a button. But I [...] Read More...
    Filed under:

  • Conditionally Load Excel Add-ins

    I currently have 17 add-ins loaded. Can that be right? Let me count again. Yep, seventeen. Six of the add-ins live in C:\Documents and Settings\Dick.NEBRASKA\Application Data\Microsoft\AddIns\, which is the default location for add-ins on my machine. There are a couple that live elsewhere on my local drive. It all [...] Read More...
    Filed under:

  • Euler Problem 124

    Euler Problem 124 asks: The radical of n, rad(n), is the product of distinct prime factors of n. For example, 504 = 23× 32 × 7, so rad(504) = 2 × 3 × 7 = 42. If we calculate rad(n) for 1 <= n <= 10, then sort them on rad(n), and sorting on n if [...] Read More...
    Filed under:

  • Friday Notes

    Contextures is having a contest. There are some great prizes, so go enter. If I win the VSTO book, I’ll assume it’s a divine sign and actually learn something .NET. Recently, I changed a program that I substantially completed a year ago. There was a lot of Excel and Access integration and I [...] Read More...
    Filed under:

  • Excel Word Search Generator

    Debra at Contextures blogged about creating a word search puzzle while she nursed a hangover (although she won’t admit it). Creating a word search puzzle in Excel seemed like a fun exercise, so I set about doing it. It’s not even close to finished, I’m just throwing the first draft out there to see what [...] Read More...
    Filed under: ,

  • VBA Random Integers

    Every time I post code that includes picking a random integer, Tushar reminds me that my methods produce biased results. The last time, I swore to myself I would do it right. Here's how the old me would have done it: Sub RandTest1()         Dim lRand As Long     Dim i As [...] Read More...
    Filed under:

  • Euler Problem 112

    Euler Problem 112 asks: Working from left-to-right if no digit is exceeded by the digit to its left it is called an increasing number; for example, 134468. Similarly if no digit is exceeded by the digit to its right it is called a decreasing number; for example, 66420. We shall call a positive integer that is neither increasing [...] Read More...
    Filed under:

  • Office 2010 Trailer

    via Tony’s Microsoft Access Blog Read More...
    Filed under:

  • Delete vcf Attachment from Incoming Emails

    An attachment with a vcf file extension is a little calling card that comes along with some people's email. Presumably, I can use that information to update my contacts quickly and easily. I'm not sure which email programs have this on by default, but I don't think Outlook does. If it did, [...] Read More...
    Filed under:

  • Using Windows 7 Libraries with Older Excel Versions

    I’m what you might call a late adopter. My computers all have Windows XP on them. So if sounds like I don’t know what I’m talking about, well, I don’t. But KeepITCool sent me a Windows 7 tip that just has to be shared. Ars sez Windows 7 has a new file management concept [...] Read More...
    Filed under:

  • First to 40,000

    So apparently today is a big day for everyone that measures dates from a certain arbitrary date in the past. Yes, that means you and me. But Martin claims he saw it first. Apparently in New Zealand, the sun comes up really early. J-Walk is looking forward to September 5, 2021, while I’m [...] Read More...
    Filed under:

  • The Mystery of the Disappearing Range Name

    Hi all, As some of you may be aware, Excel 2007 has been exhibiting an obscure but very annoying bug. On some rare occasions, Range Names may disappear from your workbook after saving it. I have never been able to detect any pattern in this behaviour, it just happens on and off. I’m happy to say Microsoft created [...] Read More...
    Filed under: , , ,

  • June Stats

    The Spreadsheet Page Pointy Haired Dilbert Read More...
    Filed under:

  • Interrupting Calculations

    Normally, Excel calculates your workbooks so fast you don’t notice. Sometimes, however, your workbook is so big that it takes Excel some time to calculate it. I’m guessing readers of this blog run into that situation more than the average Joe. While Excel is calculating, the status bar displays its progress. [...] 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.