Browse by Tags

Sorting a Custom Collection Class

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. Let’s say I have a [...] Read More...

Published Mon, Oct 10 2011 2:50 AM by Daily Dose of Excel

Filed under: General, Classes, VBA Advanced, Collections, VBA, Downloads, VBA Code Library, Modules

Spot the 10 differences

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 give you an easy way to [...] Read More...

Published Fri, Sep 09 2011 1:24 PM by Daily Dose of Excel

Filed under: VBA Advanced, VBA, MVP, Downloads, Automation, VBA Code Library, Excel Advanced

Pitch Template

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 win. For my tournament, we [...] Read More...

Published Thu, Mar 03 2011 6:30 AM by Daily Dose of Excel

Filed under: Downloads

Name Manager Updated

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 name. I’m now off to [...] Read More...

Published Tue, Feb 02 2011 12:28 PM by Daily Dose of Excel

Filed under: Excel12, MVP, Downloads, Names, Excel 14

Bulging Squares

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...

Published Sat, Oct 10 2010 8:08 AM by Daily Dose of Excel

Filed under: General, Downloads

TableMaker 2.0

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...

Published Fri, Oct 10 2010 4:47 PM by Daily Dose of Excel

Filed under: General, Downloads

A Hundred Thousand Name Managers!

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 today I [...] Read More...

Published Thu, Aug 08 2010 3:55 AM by Daily Dose of Excel

Filed under: MVP, Downloads, Add-ins, Names

The True Cost of Spreadsheets

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...

Published Wed, Aug 08 2010 7:30 AM by Daily Dose of Excel

Filed under: General, Downloads

Button image add-in for 2007 and 2010

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 my [...] Read More...

Published Wed, Jul 07 2010 3:06 PM by Daily Dose of Excel

Filed under: Excel12, Downloads, Excel 14

Generate Sample Data

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 [...] Read More...

Published Thu, Jun 06 2010 7:00 AM by Daily Dose of Excel

Filed under: Downloads

Using the MATCH Function for a Linear Search and a Binary Search

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 [...] Read More...

Published Wed, Mar 03 2010 3:43 PM by Daily Dose of Excel

Filed under: General, Downloads

Quick Find Regular Expressions

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 More...

Published Mon, Aug 08 2009 9:00 AM by Daily Dose of Excel

Filed under: Downloads

Quick Move

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 [...] Read More...

Published Fri, Aug 08 2009 9:00 AM by Daily Dose of Excel

Filed under: Downloads

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...

Published Tue, Jul 07 2009 5:22 PM by Daily Dose of Excel

Filed under: Downloads, Games

Adding RibbonX code to an Office OpenXML file using VBA

My previous post went a bit unnoticed, but I bet this one might interest some of the Office developers… In that post, I showed how to access and modify existing parts of an Office OpenXML package. This opens up the path for us to add ribbon customisation code to an Office file. For this to happen, [...] Read More...

Published Mon, May 05 2009 1:42 PM by Daily Dose of Excel

Filed under: Excel12, Classes, VBA Advanced, MVP, Downloads

Syndication

Recent Posts

Tags

News

Archives

Sorting a Custom Collection Class

Spot the 10 differences

Pitch Template

Name Manager Updated

Bulging Squares

TableMaker 2.0

A Hundred Thousand Name Managers!

The True Cost of Spreadsheets

Button image add-in for 2007 and 2010

Generate Sample Data

Using the MATCH Function for a Linear Search and a Binary Search

Quick Find Regular Expressions

Quick Move

Excel Word Search Generator

Adding RibbonX code to an Office OpenXML file using VBA