Excel Tips
Counting Cells by Interior Color Using VBA »
April 17, 2002
How to count cells by interior color using VBA.
Filename Derived From A Cell »
April 16, 2002
How can I write an Excel VBA macro to save the current Excel file with a filename derived from cell A1?
Splitting The Contents of a Cell »
April 16, 2002
How to split the contents of a cell in to columns.
Expand Excel Chart Using Drag Drop »
April 9, 2002
Here is a cool & easy Excel charting tip for those of us who must re-do Excel charts each week, month, quarter or year to reflect a new data point.
March 26, 2002
Excel 97 introduced new User Forms. In English, teach me how to create and use a list box.
March 19, 2002
How can I write a macro which will take Excel spreadsheet data and create a Word file for each row of data?
March 12, 2002
There are hundreds of Excel keyboard shortcuts, but no one can remember all of them. Here are a few of my favorites that you can start with.