Click Here For The New Main Page
Software Consulting, LLC
Your Source For Expert Excel And VBA
Most Valuable Professional
9 Years Running
1999 - 2007
Search The Site
Read This Before Sending Me
Note: Phone Number Is For
Existing And Potential Clients Only. If you call me seeking help, be
prepared to pay for 1/2 hour of consulting time.
Please call after 9AM USA Central Time
This web site is brought to you as a public service by
Pearson Software Consulting, LLC and
Chip Pearson. PSC provides complete Excel, Office, and Visual
Basic solutions for your business. From simple workbooks to complete
applications, we can make the power of Excel and Office work for your
business. You have Excel. Learn how to turn Excel into a powerful
application platform. Contact Chip Pearson at (913) 432-5676 for more
Note: Formulas appearing on this site will work in any version of Excel. The
VBA code will work in Excel97 and later, unless specified otherwise. While
little of the code has been tested in Excel 2007, you shouldn't have any
problems using the code and formulas in Excel 2007. Code that works only in
2007 will be indicated as such.
There are presently 191 pages on the
site, with 155 downloadable zip files.
Site News, 28-May-2007: Over
the next few months, I will be converting the web site from plain HTML to
ASP.NET 2.0. I will leave the original HTML site up and running, so
you should still have access to all the pages. However, as pages are created
to ASP.NET, you'll see a new look and feel, and there might be some broken
links. Please be patient as the transition to ASP.NET 2.0 takes place. Also,
I will be switching hosting providers, so there may be a short period during
which the web site will be unaccessible, as the DNS servers get updated with
the new location. Thank you for your patience and understanding. I hope the
transition will be painless for both you and me.
What's New On
The Web Site
The list below shows only the ten most recent updates
to the site, out of over 170 pages. For a complete chronological list of
updates to the site, see the
What's New page. For a more or less
complete list of pages on the site, see the
Page Index. To find information about a specific topic, see the
Topic Index, or
Search the site here.
This page describes how to use multiple monitors in Excel.
This COM add-in lets you save a zipped copy of any open workbook, with
option password protection and file encryption.
Additional Functions On
Three new functions, AverageByColor, MinByColor, and MaxByColor have
been added to the Colors page.
ListBox Utilities (11-March-2007)
This page contains about a dozen VBA procedures
designed to make the MSForms ListBox easier to use. The module includes
procedures for moving sets of list items up or down in the list box and
a sorting functions.
Recursive Programming And The
Recursive programming, in which a procedure calls itself, it a powerful
programming technique. This page describes recursive programming using
the FileSystemObject to create a directory tree listing.
Updated Code For Directory Tree Listing
New options have been added to the Directory Tree listing add-in.
Additional, a help file is available.
Suppressing Events On A User
The Application.EnableEvents property
does not apply to events of controls on a UserForm. This pages describes
simple code you can use to implement your EnableEvents property of a
Delete Blank Rows (23-Feb-2007)
The DeleteBlankRows procedure has been completely rewritten to preserve
cell references and avoid #REF errors.
Testing Whether A Series
Of Numbers Is In The Correct Order (16-Feb-2007)
The formula described in this section of the page
determines whether a series of numbers in a column increases or decreases by a
specified interval. The formula returns 0 if all the values are separated by the
prescribed value, or a positive number indicating the number of values out of
Insert Procedure Names
Automatically To VBA Code (15-Feb-2007)
This page contains a function called
InsertProcedureNameIntoProcedures and supporting function that allow you
to automatically insert the name of each procedure into that procedure
with a CONST declaration.
This pages describes how to show a UserForm that is to be determined at
runtime. It utilizes the often forgotten about VBA.UserForms object and
CallByName to access a form and its controls using string variables
whose values are set a run time.
Calling Functions In A
COM Add-In or Automation Add-In From VBA
You can call the functions in a COM Add-In or Automation Add-In Public
Class from other VBA code, in addition to calling them from worksheet
cells. This pages describes how to call the functions from other VBA
Building A Listing Of Subfolders And
This page describes and has downloadable files for
creating a listing of all the subfolders and files (and their subfolders
and files) of any folder.
All of the code and formulas on all
the pages of this web site are explicitly granted to the Public Domain. That
means that I give up all intellectual property rights to the code, in
exchange for zero-liability for the fitness-for-use of the code. No
warranty, express or implied, is given with the code and/or the formulas. You are
free to use any code or formula on this site in any way you see fit,
including using them in other commercial applications. All I ask in return
is that if you do use the code or formulas in other applications or on
another web site, you put a reference to this web site and/or the specific
web page address or downloadable file in the your code and/or in
related documentation. The descriptive text that accompanies the code
and formulas is not in the Public Domain, and is � Copyright,
1998 - 2007 Charles H Pearson.
Legalese: Microsoft Windows, Windows95,
Windows98, Windows ME, Windows NT, Windows XP, Windows Vista, Excel, Word,
Office, Visual Basic, VBA, Visual Studio, FrontPage and other product names
used on this site may be trademarks or registered trademarks of Microsoft
Corporation. Any other product names used on this site are the property of
their respective owners. Microsoft Corporation is in no way connected with
or affiliated with this web site or its contents and makes no endorsement of
any sort of the site or the contents within the site. The MVP Award and the
use of the MVP logo does not imply any endorsement by Microsoft of this web
site or its contents. No warranty, express or implied, is given with this
site and the code and/or formulas contained within the site. Use the
formulas and code as you see fit at your own risk. By using the code and/or
formulas contained in this web site, you agree that the owner(s) and/or
author(s) of this site and its contents are not responsible for any problems
or errors that may occur by use the code and/or formulas.