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

April 2008 - Daily Dose of Excel

Sort by: Most Recent | Most Viewed | Most Commented

  • Efficient Looping

    In a previous post, I demonstrated how to use constants to improve your code. Then everyone started beating up my loop. The code wasn't solving a real life problem, so I just threw any old loop together. It wasn't relevant because that's not what the post was about. To fight back, [...] Read More...
    Filed under:

  • Testing Strings Using Left

    The "wrong" way: Sub FindTotals()         Dim rCell As Range         For Each rCell In Sheet1.Columns(1).Cells         If Left$(rCell, 5) = "Total" Then             'Do something         End If     Next rCell     End Sub The "right" way: Sub FindTotals2()         Dim rCell As [...] Read...
    Filed under:

  • Printing First Page of Email in Outlook

    I print out my email. No, I'm not one of the Luddites that prints out every email (or has his secretary do it) because he doesn't understand how to work his email machine. My system for organization is loosely based on Getting Things Done and its derivative 43 Folders. Everything I have [...] Read More...
    Filed under:

  • VBE Bookmark add-in for Office 2000-2007

    Hi all New page on my site with a very useful add-in from Jim Rech. http://www.rondebruin.nl/vbebookmarks.htm VBEBookmarks.dll is a simple COM Add-in created by Jim Rech for the Microsoft Office 2000-2007 Visual Basic Editor which lets you bookmark up to five locations in VBA projects for easy navigation among them. Have fun Ron de Bruin http://www.rondebruin.nl/tips.htm Read More...
    Filed under: , ,

  • I’ve Arrived

    I’m in Seattle for the MVP Summit. This hotel is great. I just downed a whole jar of complimentary Macademia nuts and… What’s this thing that looks like a menu? Damn! I’m off to register and score some of the Rock Bottom brew. I’ll be sure to have one for those [...] Read More...
    Filed under:

  • Mike Won!

    Mike from the Northeast won the 4-year anniversary contest. A copy of Dalgleish’s Excel Pivot Table Recipes is soon to be rushing to his house from wherever Amazon rushes stuff. In the contest, I asked for your favorite non-Excel blogs, and here are some of them: Office Live Small Business… - Why are Microsoft [...] Read More...
    Filed under: ,

  • Tab Groups

    Scott wishes: G’day Dick, My wish list would be to have the functionality to group excel tabs within a workbook. So instead of having 20+ tabs going along the bottom of the screen you could group (similar to TabScrip in VBA ) them into a common theme. Maybe group all the raw data tabs, input [...] Read More...
    Filed under:

  • Copy Paste to External Application

    Sometimes I find myself copy-pasting between Excel and another application. In this example, I have a table of three columns: First Name, Last Name, Birth Date. My external application has 3 text boxes, one for each of those values. I can't just copy the 3 cells from Excel and paste them to my App, because they would all [...] Read More...
    Filed under: ,

  • Getting the Printer Port

    Do you know how windows appends that "on Ne01" to your ActivePrinter. In the old days we had to loop through all the possible digits to find which one didn't error out. Well no more! Holger uses the registry to find the printer port. Very clever. However, if you have back slashes [...] Read More...
    Filed under:

  • Investing in Lean

    I’m a big fan of the Toyota Production System. I was thinking that I should find a mutual fund that invests in lean companies, but I couldn’t find one. I searched for “best lean companies” to see if I could get a list, and found Who Are the Best Lean Companies at leanblog.org, [...] Read More...
    Filed under:

  • Updating Stock Quotes

    I answer about four questions a month on the newsgroups. I'm off to a roaring start in April, but I don't like my answer much. I never know just how "correct" an answer to give. So I gave an answer that I felt was appropriate for the original poster and I'll give [...] Read More...
    Filed under: ,
Copyright Excel User Group and the relevant contributors, 2008. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.