-
This post written by Daniel Ferry, an Excel MVP, chronicles how he and Beth Melton, a fellow MPV, designed a Gradebook template in Excel that makes teachers’ lives a whole lot easier. Several teachers, however, wanted to make the template even more useful. They asked us whether the template could...
-
I’ve been following Dick’s VBHelpers Build series (1, 2, 3) and his last post reminded me that, from time to time, I need to sort a collection of items in-memory.
I don’t have to sort all that often, so my approach has changed over time. I’ve kind of settled on the following....
-
Hi everyone!
Yesterday I experienced the tedious task of figuring out what the differences are between the VBA projects of two different versions of a customer project I built a long time ago. Luckily there are tools to compare differences in text files, such as ExamDiff.
But the VB editor doesn’t...
-
From Wikipedia
Pitch is an American trick-taking card game derived from the English game of All Fours (Seven Up). … The modern game involving a bidding phase and setting back a party’s score if the bid is not reached.
The only “real” pitch is four-point, keep low, bid or set to...
-
Hi All,
I’ve just updated Charles Williams and my Name Manager utility.
New in this version is that when you delete a range name, you will be asked whether you want to unapply the range name in your formulas. This should effectively prevent any #NAME! errors from surfacing when you remove a range...
-
I found this Bulging Square illusion on my iPad, and then I found that Excel Hero had already done it as The Bulging Checkerboard. But Daniel did it as a chart, no VBA. Here is my interpretation with VBA, no chart.
The first step was to make the cells square. Cell dimensions are [...] Read More...
-
Dick very recently put up a function that takes an Excel range and whips up some HTML to create a table. I loved that idea, and I asked if I could flesh it out. With Dick’s green light, I created a Sub() that captures each cell’s font family, font style, and font color, [...] Read More.....
-
Hi folks,
Many of the regulars here probably know the Name Manager utility, which Charles Williams and I created and give away for free on our websites.
Rumour has it this is one of best tools ever built for the Excel developer. I won’t argue with that!
Anyway, as I was looking at my web stats...
-
Rob wrote a white paper called Spreadsheet Addiction: The True Cost to the CPG Industry. In it, he lists the reasons why Excel is so popular and widely used and he lists the reasons why it costs more than you think. I’d excerpt some of that text, but I don’t know how to [...] Read More.....
-
Hi all
I want to let you know that I upload a new version of Jim Rech’s button image add-in today.
You can find it in the “Find the names of the button images” section on my Ribbon page.
This great Add-in is working now in Excel 2007 and in Excel 2010.
While you there check out also...
-
I’ve long been a fan of Jimmy Pena’s Random Sample Data Generator Add-in and I use it quite a bit. I wanted to write my own, however, and introduce a little more flexibility. In particular, I was creating some sample inventory data and I needed to create inventory part numbers. My part [...
-
Given the problem I have with images and blog posts, I’m trying something new. I uploaded the content of the post to my website and am using an iframe to post it here. Yes, the UI experience is somewhat different than scrolling the entire browser window but hopefully it is something most people...
-
I thought I’d add regular expressions to my Quick Find utility. I’ve used regular expressions about a dozen times in my life, so why not clutter up a simple tool with it. Now if I start my search string with rx: it will evaluate the rest as a regular expression. My problem is when [...] Read...
-
In my continuing series of tools to save myself literally seconds every day, I present Quick Move. See also QuickTTC, QuickPivot, and QuickFind. Even though I'm a keyboard guy, I tend to move or copy sheets within a workbook using the mouse. I generally only use Edit - Move or Copy Sheets when I...
-
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...