I ran into this the other day when I was working on a file and it drove me nuts. Background: I always use a custom property to contain my RibbonUI object. It's set up like this: The following code goes
I was working on my budget package today, and decided that I wanted to break the text so that it showed on two lines. For many novice users this means that they put one or two words in one cell,
My wife sent me a message today to let me know that a review copy of Professional Excel Development: 2nd Edition had just arrived at my door. 🙂 The last version of the book was excellent: the only book on
A Little Background My staff and spreadsheet users will tell you that any time I build a spreadsheet, there are always shaded cells on the grid. I preach that "Green means go", and make sure that any cell they enter
I recently taught a course and, while this wasn't actually covered in the course content, we did discuss it. I've found that every time I demonstrate this technique, it gets some "oohs" and "aahs", so I figured that I'd share
I really like the new icon sets that are in Excel 2007. They're kind of a neat way to format a cell to show interpretive information at a glance. One practical place to use these is as an alternative to
In a blog post last week, I was looking at the image formats to use when I snapped a picture of a chart. I'm kind of glad that Jon agreed with my assessment on EMF being the best image format
*Note: The charts in this post are based on sample data and do not reflect any real financial performance. In setting up my first dashboard, I took a page out of Charley Kyd's book and placed a bunch of little graphs
I'm not sure if the observation is weird, or the actual chart sizing is. I think this is a bug, but I'm curious if others see similar behavior. This is an Office 2007 thing (at least, I haven't tested it
So during my infatuation with converting my workbook to use IFERROR statements throughout, I suddenly realized that the reports I had to send to head office needed to work in Excel 2003. After a bit of... um... motivational speaking... I
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.
