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

Browse Blog Posts by Tags

Showing related tags and posts for the Blogs application. See all tags in the site
  • Welcome to “Excel…not quite finished” week.

    A couple of days ago I floated the concept of a dedicated annual “Still Broken” week in which we can talk very honestly about the things in this otherwise great application that we think are still broken, plus review our list from the same time last year to see if any action has been taken […]...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Sun, Mar 8 2015
    Filed under: Filed under:
  • Why not let users trigger macros from a UDF?

    I like Colin Legg’s cool code over at Self Extending UDFs – Part 1 and Self Extending UDFs – Part 2. And I keenly await Self Extending UDFs – Part 3 (subtitled Return of the User-i or something similar) If you haven’t seen those articles, go check ‘em out…they show you how you...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Thu, Mar 5 2015
    Filed under: Filed under:
  • Custom Table Styles

    Whenever I look at the default Table Style that Excel spits out:       …I think: Nice structure. Pity about the finish. That formatting is a bit eyestrain-inducing , if not migraine-producing. I’m going to have to sand that sucker back to the wood, and repaint it. So I look...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Fri, Feb 27 2015
    Filed under: Filed under:
  • Converting an Excel Range to HTML the Hard Way

    Every time I write a RangeToHTML function, it’s different. I don’t re-use my old functions because the HTML elements that I care about change from project to project. I could make a generic RangeToHTML function that attempts to capture every possible cell property, but I don’t. I don’t...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Fri, Feb 13 2015
    Filed under: Filed under:
  • Go To Special Blanks no longer my Go To guy…

    So I’ve always used Excel’s Go To Special and VBA’s SpecialCells method to select things like formulas, constants, blanks etc from large ranges because I was under the impression that this was efficient. Is is, unless you’re using it to find blanks, in which case it’s a...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Tue, Feb 10 2015
    Filed under: Filed under:
  • Quick Access Toolbar Usage Update

    Ever since the great QAT Usage Survey of last year, I’ve had five controls on my QAT. Up from zero. Here’s how they’ve fared. Borders: Used zero times. I have my two most common border situations (single underline and grand total) available elsewhere. I guess I don’t muck around...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Fri, Jan 23 2015
    Filed under: Filed under:
  • First bug of the year

    And it’s a funny one. Save all your work, then make up a simple datasource that has a formula in the header:       Now, turn the Macro Recorder on, and while it’s recording, turn that datasource into an Excel Table. (I use the Ctrl T shortcut for that)      ...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Wed, Jan 14 2015
    Filed under: Filed under:
  • What Is the Most Awesome Microsoft Product

    As if you didn’t know. As the people talked, we started to get a sense for why they thought Excel is cool – Excel enables people to be rockstars at their jobs and get recognition from their peers. Excel makes people feel powerful. Excel is a work tool that people *love* to use. You can […...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Tue, Jan 13 2015
    Filed under: Filed under:
  • Evaluate Mid

    In my last post, I created an array from formula text by using VBA’s Evaluate method, in order to roll my own FormulaArray function that displays the array returned by a formula, for documentation purposes. In the course of this, I’ve discovered something a bit weird about how this method evaluates...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Wed, Dec 3 2014
    Filed under: Filed under:
  • Evaluate(Evaluate)

    Since Excel 2013, Microsoft has given us a FORMULATEXT function, which if you point at a cell will do just that. Here’s a naughty snapshot of FORMULATEXT playing with itself in the corner:       I thought I’d have a go at writing a FormulaArray function to complement it, because...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Mon, Nov 24 2014
    Filed under: Filed under:
  • Out, damn’d gridlines! Out, I say!

    So after doing some incredibly complicated formula challenges and ninja-grade VBA, I thought I’d turn my hand to something simple: finally changing the default template that loads when Excel starts or when I create a new workbook or worksheet so that gridlines are turned off. Because if there’s...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Thu, Nov 20 2014
    Filed under: Filed under:
  • Dynamically extracting the nth numerical element without delimiters

    ExcelXOR has a great post on using formulas to extract all numbers from a string where: The string in question consists of a mixture of numbers, letters and special characters The numbers may appear anywhere within that string Decimals within the string are to be returned as such The desired result is...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Thu, Nov 20 2014
    Filed under: Filed under:
  • An INDEX of insights from ExcelXOR

    Everybody knows that you can’t do some things with the result of an INDEX function unless you return it to the worksheet first. For instance, I can return the 2nd and 3rd members of the array {10,20,30} to the worksheet with an array-entered INDEX function like this:       …but if I wrap...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Thu, Nov 20 2014
    Filed under: Filed under:
  • Cult of the Flying Spaghetti VLOOKUP

    Sumit Bansal’s post VLOOKUP Vs. INDEX/MATCH – The Debate Ends Here! sparked some great discussion on the merits of VLOOKUP vs INDEX/MATCH, including at Oz du Soleil’s lighthearted rebuttal at The Anti-VLOOKUP Crowd Is Out In The Streets Again! I especially love Peter B’s comment at...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Mon, Nov 17 2014
    Filed under: Filed under:
  • String concatenation is like the weather…

    …everyone complains about it, but nobody does anything about it. Well, certainly not Microsoft, anyhows. But Nigel Heffernan at Excellerando.Blogspot.com has. A whiles back in 2012 he put up some nifty code for joining and splitting two dimensional arrays that I just stumbled across. I thought...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Fri, Nov 14 2014
    Filed under: Filed under:
Page 1 of 6 (83 items) 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.