Archive for the ‘General’ Category.

Google Chrome

This week I made the switch from Firefox to Google Chrome. The latest stable release of Chrome supports “extensions” so all those pesky annoyances that kept me away from Chrome in the past can be fixed. My only complaint with Firefox is that I have to restart it a couple of times a [...]

Perfect Training

Have you even attended a really good training session? What about it made it good?
I’d like to develop some training sessions. I get a lot out of preparing and presenting (and I hope the attendees get something too). Rather than developing training that looks like every other session I’ve attended, I thought it [...]

MZ Tools Non-Modal Dialogs

I’ve recently rebuilt my computer, which means I get to figure out all those little settings that I’m accustomed to. Since re-installing MZ Tools, the accelerator keys don’t work on any of the dialog boxes. Take the Add Procedure dialog, for instance

With this open, I click Alt+A and instead of actuating the Add [...]

Capitalizing Web Addresses

In written correspondence, which is best:

dailydoseofexcel.com
DailyDoseofExcel.com
DailyDoseOfExcel.com
www.dailydoseofexcel.com
www.DailyDoseofExcel.com
www.DailyDoseOfExcel.com
http://dailydoseofexcel.com
http://DailyDoseofExcel.com
http://DailyDoseOfExcel.com
http://www.dailydoseofexcel.com
http://www.DailyDoseofExcel.com
http://www.DailyDoseOfExcel.com

I personally prefer #1, all lowercase and no unnecessary prefix. But I think I’m in the minority. One of the capitalized ones is probably easier to read, but I’m no sure about the “of”. Thoughts?

2009 in Review

Top 10 Page Views in 2009

Post
Page Views

Creating CSV Files
33,947

Sumif Between Two Dates
19,336

Number Stored as Text
15,003

Writing to a Range Using VBA
12,165

Automating Internet Explorer
11,248

Progress Bar
11,212

Testing for Empty Cells
10,581

Pattern Matching
9,665

Calculated Fields in Pivot Tables
9,321

Maxif Minif Functions
8,162

Most Viewed 2009 Posts

Post
Page Views

Vlookup on Two Columns
6773

Vlookup
2695

Get the Path to My Documents in VBA
2258

Excel Sample Data
2230

Reading Xml Files in VBA
1710

Bingo
1673

Illegal Range Names
1576

Creating [...]

New content on my site about 2010

Hi all
I create a 2010 section on my Tip index page with the first pages about 2010.
http://www.rondebruin.nl/tips.htm
Load different RibbonX when opening file in Excel 2007 or 2010
Download to find the names of the Excel 2010 ControlIDs (819 kb)
Backstage view in Excel 2010
I not say they are good but this are my first examples that I [...]

Multiple Substitute Formula

MaryAnn asks an interesting question.

In column A there is text that may or may not contain the name of a US state. In column B there is a list of US states. In column C, we want the column A text without the state names. I think this would be a pretty [...]

Benford’s Law

J-Walk posted about Benford’s law and I thought I’d test it out. I found an Excel file with a lot of numbers, namely a price list. In a new workbook, I put the following code:
Sub MakeNumbers()
   
    Dim wb As Workbook
    Dim ws As Worksheet
    Dim rCell As Range
  [...]