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

Blogs

  • Converting Numbers to Words Part III

    See Converting Numbers to Words Part II My tests work from 0-99. The next test will test numbers between 100-199. Sub TEST_OneHundred()     Debug.Assert NumbersToWords(100) = "one hundred"     Debug.Assert NumbersToWords(110) = "one hundred ten"     Debug.Assert NumbersToWords(119) = "one hundred nineteen"     Debug.Assert NumbersToWords(120) = "one hundred twenty"     […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Mon, Jun 30 2014
    Filed under:
  • Converting Numbers To Words Part II

    See Converting Numbers To Words Part I. The next test will test 20-99. I think in real TDD, you’re supposed to write tests that test just one thing. But I’m not doing real TDD, so I’m testing in groups. Sub TEST_Tens()     Debug.Assert NumbersToWords(20) = "twenty"     Debug.Assert NumbersToWords(21) = "twenty-one"     […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Fri, Jun 27 2014
    Filed under:
  • Converting Numbers To Words Part I

    I overheard two people talking, one of whom was showing his intellectual prowess using that puzzle whose answer is always ‘four’. I don’t remember the specifics of the game, but you count the letters of an integer, do some basic math, and you always end up with ‘four’ because the word ‘four’ has that many […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Thu, Jun 26 2014
    Filed under:
  • Playing Peekaboo with the Used Range

    I was trying to reset the used range in a spreadsheet template I inherited the other day, that had a much bigger used range than it should have had. Damned if I could get it to reset. Tried deleting rows and columns below and to the right of the actual used range. Tried this: Sub […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Mon, Jun 16 2014
    Filed under:
  • T Accounts

    I’ve made an Excel template for filling out T accounts. For you non-accounting folks, a T account is a method to trace accounting transactions through the accounts on the general ledger. Hey, wake up! This post isn’t finished yet! I’ve made a T account template at least three times in my Excel career. They never […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Fri, Jun 13 2014
    Filed under:
  • FastExcel V3 Released – At Last!

    As some of you may know I have been working on developing Version 3 of my FastExcel product for more years than I care to remember. First there was the VB6 blind alley, then 64-bit and multi-threaded calculation and that ribbon thing, then I detoured into learning C++ and XLLs, then there was the inevitable […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Thu, Jun 12 2014
    Filed under: , ,
  • Tiered Commissions and Counting Zeros

    I was writing some formulas for a tiered commission calculation recently that I thought I should post. But beyond just what the formulas do, it reminded me that I’ve never shared my ‘counting zeros’ opinion, so I’m wrapping that in with this post too. You have a commission structure where you pay your salesmen 5% […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Thu, Jun 12 2014
  • AutoHotkey in the VBE

    I downloaded AutoHotkey recently for something not Excel related. Well, it was kind of Excel related so I guess I’ll tell the story. I’ve been using the Save As feature of my Kwik Open add-in and really enjoying the lack of folder navigation. But it has sewn the seeds of discontent. When I’m doing a […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Mon, Jun 9 2014
  • Excel Function Bible released

    Hi all Together with Norman Harker I add this page to my website : Excel Function Bible The Excel Function Bible is aimed at providing meaningful and practical help in finding and implementing the 468 Excel functions. It replaces and adds significantly to the help users can call for whilst building or using Excel workbooks. To […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Mon, Jun 2 2014
    Filed under:
  • 2048… Excel Style!

    Occasionally on the blog we like to feature the many creative and unexpected ways in which people are using Excel to solve all sorts of problems, for both work and play. For those of you who are fans of the hit mobile phone game 2048, some ingenious Excel users have created versions of the game inside of Excel! Read More...
    Posted to The Excel Team Blog by Office Blogs on Tue, May 27 2014
  • Avoiding Date Conversion When Pasting an HTML Table

    From Get Data From a Website…, MD comments: However, the info in the table I copy is formatted ## / ## whereby # represents a number. So when it tries to paste 10 / 10 in the worksheet for example, it auto-changes to 10/okt in my sheet. This is a common problem that’s hard to […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Fri, May 23 2014
  • NOT learning from my Errors

    I was writing some formulas today that need to return TRUE if a search term appears in a cell, and FALSE otherwise. For instance, I wanted to know if FOO appeared in FOOBAR or not. Originally I was using FIND, along these lines: =NOT(ISERROR(FIND(“FOO”,”FOOBAR”))) =TRUE But then had some issues with case that screwed things […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Fri, May 23 2014
    Filed under:
  • Learning from my Errors

    There’s an annoying bug in VBA whereby if you’re trying to change the .visible status of a PivotItem, and if the PivotField had a number format set to General, and if you live in New Zealand, then you’re out of luck: If you live in the US however, you’ll be fine. No error for you. […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Wed, May 21 2014
  • Wonky Keyboard Shortcut

    Check out the keyboard shortcut for the Reapply button. I don’t think I’ve ever used that button. If I need it, I think I’ll just use the mouse. Even I have limits. Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Sat, May 17 2014
    Filed under:
  • Free ApressOpen eBook: Office 365

    I’m still alive although it was quite a long time ago I published any article here. But now that I’m back I hope I will speed things up so You will see more activity of my blog. Apress have a series of books that are made available for free. The series is named ApressOpen eBooks […] Read More...
    Posted to XL-Dennis's Blog by VSTO & .NET & Excel on Tue, May 13 2014
< Previous 1 2 3 4 5 Next > ... Last »
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.