Category Archives for Guest Posts
Are Your Formulas All "Wrapped" Up?
The other day, there was a discussion on one of the LinkedIn Excel Groups regarding wrapping formulas in the formula bar. Today. I’ll take a look at wrapping and indenting formulas complete with screen shots and a workbook you may download at the end. The Data First, I’ll need some data. I use Dick Kusleika’s […]
Continue readingAre Your Formulas All "Wrapped" Up?
The other day, there was a discussion on one of the LinkedIn Excel Groups regarding wrapping formulas in the formula bar. Today. I’ll take a look at wrapping and indenting formulas complete with screen shots and a workbook you may download at the end. The Data First, I’ll need some data. I use Dick Kusleika’s […]
Continue readingGangnam Cell Styles…Delete
A reader on one of the LinkedIn Excel Groups recently asked how to delete cell styles from a workbook. Today, I’ll show a possible solution. The Cell Styles Group: List Cell Styles: I opened a workbook, Alt+F11 for the Visual Basic Editor and cooked up the code below. I then opened another workbook and made […]
Continue readingAre You Series(ous)?
Do you work with different series in your Excel charts? Here is what I would like the final chart to loo like. Note the white dashed lines in front of the columns: Setup: I started with the chart I ended with in my last post, Points Of Interest. I then added some data to a separate […]
Continue readingPoints Of Interest
Hello World! (Sorry, I could not resist J) I was recently asked by our host, Jordan, if I would be interested in being a guest author here at Option Explicit VBA. I quickly and humbly accepted. I will strive to do my best to add something of value. Let’s dive right in.I was inspired the […]
Continue readingGuest Post #1 – Dynamic Funnel Chart
Reader, Bert van Zandbergen, from Beekbergen, The Netherlands (Holland) sent me his own cool creation based on the Rollover technique I created. I asked if I could post his work to this blog to which he graciously agreed. Below is his write up. Some of the Excel functions below are in Dutch (which I think is […]
Continue reading