|
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 300 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
Topic Index.
(Last Updated 18-December-2008)
Creating A Table From A Column With Variable Block Sizes (16-December-2008)
This pages describes VBA code that you can use to create a two-dimensional table from a column of blocked
data where the data blocks are variable lenght.
Using Attributes To Describe Code In The Object Browser (16-December-2008)
You can add description attributes to modules and procedure to provide documentation in the Object Browser.
Working With The Windows Clipboard (16-December-2008)
This page describes VBA procedures for working with the Windows clipboard. It includes a downloadable module with
several useful procedures for putting text in the clipboard and getting text out of the clipboard.
FindAll XLA Add-In (13-December-2008)
This page describes the FindAll.xla add-in that allows you to search any number of
worksheets in a workbook and display all the results in a simple to use user interface.
Convert A Table To A Column Or Row (11-November-2008)
This page describes formulas to transform a two dimensional table of rows and columns into a single row or single
column of data, in either row-by-row or column-by-column order.
Convert A Column To A Table (11-November-2008)
It is not an uncommon task to convert a column of data, grouped into logical blocks, to a two dimensional table of
rows and columns. This page describes how to do this with formulas and with VBA code.
Testing If An Array Is Sorted (9-November-2008)
Sorting an array is an expensive operation in terms of memory access and processing overhead, and this problem only gets worse
as the array gets larger. This page describes how to test is an array is already in sorted order and therefore does not
need to be sorted again. In conjunction with this page, the Sorting Arrays page has
been rewritten.
Get What's New via RSS Feed (20-Oct-2008)
You can now get What's New On The Web Site information via an RSS feed. Point your RSS aggregator or your browser to
http://www.cpearson.com/RSS.xml.
How To Use Support Newsgroups Properly (19-Sept-2008)
One of the best avenues to get support and answers for Excel is through the NNTP USENET system of the
Internet. This page desribes how to connect to the Excel newsgroups and provides a list of
guidelines to follow when posting messages to the nwesgroups.
Formulas To Test Prime Numbers (15-Sept-2008)
While Prime Numbers have little practical use, especially in the sorts of things done in Excel, they
have fascinated mathematicians since the dawn of time. This page presents a formula that can
test if a number is a Prime Twin, a Prime, or not a Prime, all with a single formula.
Waiting For Shell'd Commands To Finish (9-Sept-2008)
The VBA Shell function starts a process and immediately returns to VBA. This
page describes code in a procedure name ShellAndWait that you can use to wait for the shell'd
command to terminate before returning control back to the calling procedure.
Working With Hidden And Visible Cells (4-Sept-2008)
This page describes how to work with hidden and visible cells, such as counting or summing the values
in visible cells.
Shuffling An Array To Random Order (31-July-2008)
This page describes VBA procedures to shuffle the contents of an array into random order.
Using Windows API Functions To Modify UserForms (7-May-2008)
This page describes how to modify a UserForm (adding, for example, a Maximize and Minimize button) using Windows API functions.
A Better NETWORKDAYS (7-May-2008)
The NETWORKDAYS is fine if your work week is Monday through Friday. However, if
you work week begins and ends on differentdays of the week, NETWORKDAYS is of no
use. This pages describes two formulas that allow you to specified days and holidays from the count.
Time Zones And Daylight Savings Time (6-May-2008)
This page describes VBA functions for working with time zones and daylight savings time.
Testing If A File Is Open (3-May-2008)
This page describes a function named IsFileOpen that determines whether a file
is open by another process. You can use this function to prevent Permission Denied runtime errors.
File Extensions And VBA Programming (15-March-2008)
By default, Windows does not display file extensions in Explorer windows. This setting affects how VBA code works in
Excel. This page describes how to write code to prevent problems caused by the Hide Extensions Windows setting.
Color Functions (6-March-2008)
This page describes a number of functions related to colors that you can call from VBA and from worksheet formulas
and array formulas. Available for download is a bas module with about
20 VBA functions related to colors.
RowLiner Add-In (18-February-2008)
The RowLiner XLA add-in has been enhance to support windows with Freeze Panes and Splits.
|