This web site is brought to you as a public service by Chip
Pearson and Pearson Software Consulting, LLC. We provide complete
consulting and custom application design and development for Excel, Office, Visual Basic,
and the NET Framework in VB.NET and C#.
For more information about how to turn Excel into a powerful application platform,
contact Chip Pearson at (816) 214-6957.
This web site contains about 500 individual topic pages that together cover all aspects of
Excel, from simple formulas through Automation and COM Add Ins and into the NET
Framework. The content is aimed
at the intermediate level user although there is plenty of content for both beginners and expert users. Much
of the content is VB/VBA code, and those pages assume that you are
conversationally familiar with VB/VBA programming. I have been a professional computer programmer
for almost twenty years, ten years of that in the Windows/VB/VBA/Excel world.
The topics presented on the site are drawn from my real world experience. There
are approximately 250 downloadable files, which include sample workbooks, VB/VBA modules,
VB Project source code and compiled DLL files.
The content of the site provides you with the tools you need to create
workbooks and VBA projects. Since it is impossible to be all things to all people,
the workbooks, formulas, and code examples are rather generic, allowing you to
readily customize them for your own particular needs. The formulas and code
appearing on this site should work in any version of
Excel, version 97 or later, unless noted otherwise. Most of the VBA code should
work in Excel 97 and later, but I do make use of the enhanced features of VBA
version 6, which was introduced with Excel 2000.
I have not yet upgraded all the modules to 64-bit Office, so some of the code may
not work in 64-bit Office, especially code that uses the Windows API functions
with the Declare syntax. Don't confuse 64-bit Office with 64-bit Windows. All of
the code will work fine in 32-bit Office, regardless of whether you have 64-bit
or 32-bit Windows.
Most Valuable Professional
1999 - 2012
Search The Site
Contact Chip Pearson
Before you send me an email,
read this page.
Note: This phone is for existing and new clients only. If you call,
please be prepared to pay for 1/2 hour of consulting time.
Please call after 9:00 AM USA Central Time Zone.
What's New On The Site
The list below shows only the ten or so most recent additions to the web site
out of a total of about 500 individual topic pages. For a complete chronological list of updates, see
the What's New page. You can also locate
pages from the Page Index or the
(Last Updated 3-November-2013)
This page describes problems that can occur with the
MOD worksheet function and the Mod operator
in VBA if you are working with very large numbers. The problem with the worksheet function was fixed
in Excel 2007 but it present in Excel 2003. The problem in VBA exists in all version of Excel, including
This page describes formulas you can
use to find the first and last elements in a row or column range, and the positions
of those elements.
This page describes VBA's built-in
debugging tools and how to use them. (5-Jan-2013)
DirTree Directory Tree Builder has a number of added
features and options. (3-Jan-2013)
This describes how to use formulas to determine the last non-blank
cell in a column or row. (24-Nov-2012)
This describes how and why you should use the Break In Class Module
error trapping setting. (27-Oct-2012)
DirTree Additional Feature. (26-Oct-2012)
A new feature has been added to the DirTree add-in that allows you to control the depth of folder
hierarchy to be processed by the scanner.
This describes formulas and code to average a range of numbers, excluding zero values. (22-Sept-2012)
Listing Worksheets In VBA (29-Sept-2012)
This page describes VBA code to get a filtered array of worksheet names, either to the worksheet or to
This describes code for getting a list of printers installed on the machine. (22-Sept-2012)
Ordinal suffixes for numbers. (16-Sept-2012)
Passing data to and from the worksheet and VBA arrays. (13-Sept-2012)
New features to the DirTree add-in. (4-Sept-2012)
How to rename a VBA module in a VBA Project. (19-August-2012)
This describes how to rename a module in a VBProject, both manually and with code.
Parsing File And Folder Names From the CELL function. (17-August-2012)
This page describes how to parse the output of the CELL function in order to retrieve
file, folder, and sheet information.
Sending EMail With VBA (29-June-2012)
This page describes how to send a message with VBA without using Outlook.
Cell View content viewer (8-MAy-2012)
Several advances made for the CellView add-in. This allows you do display the content of a cell
byte by byte, including control and other invisible characters.
File Information Based On File Name (4-March-2012)
This page describes code that allows you to read the registry and return the ProgID and type description of
any file whose type is registered with Windows.
||This page last updated: 4-September-2012.