I was working on a little application which has a spin button on the worksheet. That spin button is linked to a cell and works just fine for my purposes. After a while though, it became apparent that I needed
I had an email exchange with Charley Kyd tonight, and I was bemoaning the fact that I couldn't link my Excel chart titles to a range. I could have sworn you could do this, but not working with charts a
Background I've been pretty up front with the productivity gains that I saw when I embraced VBA years ago. In fact, the old About Me page on my website spells it out pretty clearly: In the fall of 2002, the
Tonight we picked up an iPod Touch from our local Save-On Foods with some reward points that we'd been accumulating. This is pretty cool for a variety of reasons, including the fact that now my kid will try and scoop
I have a financial model that I set up using a grouping in some key places so that I could collapse sections of the model when I didn't want to look at them. As I was handing off the model
Today I realized that one of my GETPIVOTDATA formulas was returning an error, since there wasn't any result in the Pivot Table it was checking for data. Unfortunately, during the design of the spreadsheet I never wrapped the function with
I know it's been forever since I've blogged here, and I'm sorry to have to revive this with a rant, but... I was writing an article up for how to customize the Office Ribbon in Excel 2010, and thought I'd
Tonight I discovered that my site had been hacked... as it turns out I was running an old version of WordPress and there was some injection code fed into a security vulnerability. I've upgraded to the latest version, which has
Introduction This macro can be used to count how many files exist in a folder and subfolders. In addition, if passed the file extension, it can also be used to count only files of a specific type. (For example "xls"
This has to be one of the weirdest little programs I've ever worked with... Back in 2003 I built a database to track our liquor inventories at work. It's fairly simple in that it has a table of product details
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.
