Links from www.cpearson.com

Selva V Pasupathy, HSBC Global Resourcing, Hyderabad

Pearson Software Consulting
Pagebanner. ThreeWave Welcome. ShortFadeBar. This web site is brought to you as a public service by Chip Pearson and Pearson Software Consulting, LLC. …
Pearson Software Consulting
Pagebanner. ThreeWave Welcome. ShortFadeBar. This web site is brought to you as a public service by Chip Pearson and Pearson Software Consulting, LLC. …
Pearson Software Consulting
Pagebanner. ThreeWave Office Application Window Class Names. This page lists the window class names of most Office applications. ShortFadeBar …
Pearson Software Consulting
Pagebanner. ThreeWave About The cpearson.com Web Site. This page provides some background information about the web site. ShortFadeBar …
Pearson Software Consulting
Pagebanner. ThreeWave About The cpearson.com Web Site. This page provides some background information about the web site. ShortFadeBar …
Activate Excel Main Windows
Pagebanner. ThreeWave Activating Excel From Another Application. This page describes how to activate the Excel application when you are controlling it via …
Activate Excel Main Windows
2 Jul 2007 … Pagebanner. ThreeWave Activating Excel From Another Application. This page describes how to activate the Excel application when you are …
Page Title
6 Jul 2007 … Pagebanner. ThreeWave Adding The COM Add-Ins Menu Item. This page describes how to add the COM Add-Ins menu item to the Excel Tools menu. …
Advertise Here
Pagebanner. ThreeWave Advertise On This Web Site. This pages describes how you can advertise your product on this web site. ShortFadeBar. Introduction …
Alert Message Display Component
Pagebanner. ThreeWave Alerter Message Display Component. This page introduces the Alerter message display component ShortFadeBar. Introduction …
Alerter Program For Office Developers
15 Nov 2002 … Frequently your Excel VBA application may need to display various messages to the user, especially if you are the user and you are trying to …
Application Events
21 Aug 2007 … Pagebanner. ThreeWave Application Events. This page describes how to work with Application Events. ShortFadeBar. Introduction …
Matrix To Vector
15 Sep 2007 … Pagebanner. ThreeWave Extracting Vectors From A Matrix. This page describes Excel worksheet formulas for extracting a vector from a matrix. …
Array Formulas
7 Oct 2007 … Pagebanner. ThreeWave Array Formulas. This page is an introduction to Array Formulas. ShortFadeBar. Introduction …
Analysis Tool Pak
21 Aug 2007 … Pagebanner. ThreeWave The Analysis ToolPak Add In. This page describes the Analysis Tool Pak Add In. ShortFadeBar. Introduction …
Analysis Tool Pack
Instructions for using the Analysis ToolPak in Microsoft Excel.
Attachments In Newsgroups
From Pearson Software Consulting, your complete resource for Excel solutions.
Automation Add Ins
17 Aug 2007 … Pagebanner. ThreeWave Automation Add Ins As Functions Libraries For Excel And VBA. This page describes creating an Automation Add In …
Color Banding With Conditional Formatting
This page shows techniques in Excel97 and 2000 for using Conditional Formatting to color band rows in a worksheet, to create the appearance of accounting or …
A Better NETWORKDAYS
7 May 2008 … Pagebanner. ThreeWave A Better NETWORKDAYS. This page describes a formula you can use in place of NETWORKDAYS. ShortFadeBar. Introduction …
Blinking Text In Excel
12 Jul 2007 … Pagebanner. ThreeWave Blinking Text In Excel. This page describes how to make blinking text in Excel. ShortFadeBar. Introduction …
Browse For Folder
5 Jul 2007 … Pagebanner. ThreeWave Browse For Folder. This page describes how to display a dialog box to prompt the user to select a folder. ShortFadeBar …
Pearson Software Consulting
Pagebanner. ` Error On Page. A fatal error occured on page: /Excel/BugReport. aspx. If this problem persists, please click the ‘Notify’ button below to …
Passing Variable ByRef And ByBal
Pagebanner. ThreeWave Passing Variables By Reference And By Value. This page describes the difference between passing parameters ByRef and ByVal. …
The CALL Function
This page was written by Laurent Longre, and is included on my site at his request and with his kind permission. I have made some minor changes in …
Calling Worksheet Functions In VBA
Software Consulting Services. Calling Worksheet Functions From VBA. This page has been replaced. Click here to go to the new page. …
Calling Worksheet Functions In VBA
20 Oct 2007 … Pagebanner. ThreeWave Calling Worksheet Functions From VBA. This page describes how to call worksheet functions from VBA code. ShortFadeBar …
Changing Text Case
15 Jul 2007 … Pagebanner. ThreeWave Changing Case. This page describes changing data to upper, lower, and proper case. ShortFadeBar. Introduction …
Cells Within Ranges
17 Mar 1998 … A description of Range addressing in VBA for Excel97 and Excel2000 which does not require the Offset method.
CellView Add In
Pagebanner. ThreeWave Cell View Add-In. This page describes the CellView.xla Add -In For Excel. ShortFadeBar. Introduction …
CellView Add In
6 Oct 2007 … Pagebanner. ThreeWave Cell View Add-In. This page describes the CellView.xla Add -In For Excel. ShortFadeBar. Introduction …
Page Not Found
Pagebanner. ThreeWave Page Not Found. The requested page was not found. ShortFadeBar. Requested Page: /excel/CFColors.aspx …
Conditional Formatting Colors
27 Aug 2008 … Unfortunately, the Color and ColorIndex properties of a Range don’t return the color of a cell that is displayed if Conditional formatting …
Conditional Formatting
How to use Conditional Formatting in Microsoft Excel97 and Excel2000 to format cells based on their content, or the content of other cells.
Special Characters In Excel
This page describes methods you can use to insert special characters, such as Euro or Yen currency symbol, in Excel worksheets.
Classes In VBA
20 Jul 2007 … Pagebanner. ThreeWave Introduction To Classes. This page is an introduction to Classes. ShortFadeBar. Introduction …
Clipboard
This page describes how to read and write data to and from the Windows clipboard , using Excel 97 and 2000.
Clone Folder
27 Aug 2008 … This page describes the code to “clone” an existing folder to a new folder. The code will copy all of the files and subfolders from the …
Code Modules And Code Names
This page describes how to work with Code Modules and Code Names in Microsoft Excel97 and 2000.
Code Notes
The Excel formulas and the VBA code on this site were written for Excel97. They may work in previous version of Excel, but they may not. …
Custom Collection Class
Pagebanner. ThreeWave Custom Collection Classes. This page how to create a custom Collection Class. ShortFadeBar. Introduction …
Sorting A Collection Or Dictionary
27 Aug 2008 … The Collection object and the Dictionary object are very useful for storing groups of related data. All else being equal, I use a Dictionary …
Color Functions In Excel
6 Nov 2008 … Pagebanner. ThreeWave Color Functions In Excel. This page describes VBA functions you can use to work with colors on worksheets. …
Color Functions In Excel
Pagebanner. ThreeWave Color Functions In Excel. This page describes VBA functions you can use to work with colors on worksheets. ShortFadeBar. Introduction …
Column To Table
Pagebanner. ThreeWave Column To Table. This page describes formulas you can use to transform a column of data into a table of rows and columns. ShortFadeBar …
COM Add-Ins In Excel 2007
23 Aug 2007 … Pagebanner. ThreeWave COM Add-Ins In Excel 2007. This page describes some changes for COM Add-Ins in Excel 2007. ShortFadeBar. Introduction …
Creating A COM Add-In In VB6
Introduction To Writing COM Add-Ins And Automation Add-Ins In Visual Basic 6. Beginning in Office 2000, Office programs such as Excel or PowerPoint began …
Installing COM AddIns
Pagebanner. ThreeWave Installing COM Add-Ins. This page discusses COM Add-Ins And Installation Policies ShortFadeBar. Introduction …
Disconnected Objects
27 Aug 2008 … When you use object-type variables, those variables can become disconnected from the object they reference when that reference object is …
Consulting And Development Services
Pagebanner. ThreeWave Consulting And Development Services. This page describes my consulting and application development services. ShortFadeBar …
Consulting And Development Services
Pagebanner. ThreeWave Consulting And Development Services. This page describes my consulting and application development services. ShortFadeBar …
CountType
Pagebanner. ThreeWave CountType VBA Function. This page describes the CountType function that counts the number of cells of a given content type in a range …
Creating An XLA Add In
8 Oct 2007 … Pagebanner. ThreeWave Creating An XLA Add-In For Excel. This page describes how to write an XLA Add-In For Excel. ShortFadeBar. Introduction …
XLA Add In Sample Code
8 Oct 2007 … Pagebanner. ThreeWave Sample Code For An XLA Add-In. This page contains sample code for an XLA Add-In. ShortFadeBar …
Creating A COM Add In
Pagebanner. ThreeWave Creating A COM Add In. This page describes how to write a COM Add In With Visual Basic 6. ShortFadeBar. Introduction …
Creating A Function Library In .NET
24 Sep 2007 … Pagebanner. ThreeWave Creating A Function Library In VB.NET. This page describes how to create a Function Library in VB. …
Adding Months And Years
Sometimes it is useful to be able to enter or calculate numbers that express a number of years and months. For example, you may have a list of birthdays, …
Date Arithmetic
Worksheet formulas for doing arithmetic operations on Dates and Times in Microsoft Excel.
DATEDIF Worksheet Function
Pagebanner. ThreeWave The DATEDIF Worksheet Function. This page describes the undocumented DATEDIF worksheet function. ShortFadeBar …
Date Intervals
This page describes a few methods for working with intervals of dates. Specifically, it address the questions of whether a date falls within an interval, …
Dates And Times In Excel
29 Jan 2000 … A complete reference to working with dates and times in Micrsoft Excel and Visual Basic For Applications.
Date And Time Entry
This page describes the VBA procedures that will allow you to enter dates and times, without having to enter in the “/” or “:” separators. …
VBA Procedures For Dates And Times
Visual Basic For Applications procedures for working with dates and time in Microsoft Excel.
Worksheet Functions For Dates And Times
Worksheet Functions for working with dates and times in Micrsoft Excel.
Daylight Savings Time
Neither Excel, VBA, nor the Windows API library provide much support for working with Daylight Savings Time (DST) and Standard Time (STD). …
Debugging VBA
Once you’re written your VBA procedures and achieved clean compiles without errors, you are ready to undertake the most important step in programming: …
Declaring Variables
27 Oct 2008 … Pagebanner. ThreeWave Declaring Variables. This page describes practices you should use and practices you should avoid when declaring …
Default Member Of A Class
Pagebanner. ThreeWave Default Member Of A Class. This page describes how to specify a default method of a class. ShortFadeBar. Introduction …
Default Property Of A Class
27 Aug 2008 … THIS PAGE HAS BEEN REPLACED. Click Here for the new page. Pearson Software Consulting Services. Default Property Of A Class …
Deleting Duplicate Rows With Advanced Filter
1 Dec 2007 … Pagebanner. ThreeWave Deleting Duplicate Rows With Advanced Filter. This page describes how to use the Advanced Filter tool to delete …
Deleting Rows
Often, people ask for a macro to delete all blank rows or all duplicate rows from a range of rows in a worksheet. This page has three macros, …
Detecting Scrolling In A Worksheet Window
The Excel object model does not provide any method or event that allows you to detect when the user scrolls in a worksheet window. …
Macros And Functions
The words macro and function are often used interchangeably to refer to procedures written in Visual Basic For Applications (VBA). However, it is important …
Direct Connect To MSNEWS
This page describes why it is advisable to connect directly to the MSNEWS servers when you read and post to the Excel newsgroups. …
Distinct Values Function
5 Nov 2007 … Pagebanner. ThreeWave Distinct Values Function. This page describes a VBA Function that will return an array of the distinct values in a …
Distributing Days Over Intervals
Describes a variety of formulas to distribute dates in an interval across the intervening months or years.
DLL Name Of COM AddIn
Neither Excel nor VBA provides you with a method to get the DLL name of a COM Add-In. This page contains a procedure named DLLOfComAddin that will return …
Document Properties
5 Jan 2008 … Pagebanner. ThreeWave Document Properties. This page describes how to use the Built-In and Custom document properties of a workbook. …
Document Properties
5 Jan 2008 … Pagebanner. ThreeWave Document Properties. This page describes how to use the Built-In and Custom document properties of a workbook. …
Downloads
The files here are compressed into Zip files, which “shrinks” them down to roughly one third their original size. They can be uncompressed with any standard …
This page has been replaced by a new version. Click here to go to …
This page has been replaced by a new version. Click here to go to the new site: Duplicates.aspx.
Duplicates In Data In Excel
Pagebanner. ThreeWave Duplicate Data In Lists. This page describes techniques for dealing with duplicate items in a list of data. ShortFadeBar. Introduction …
Email Chip Pearson
Pagebanner. ThreeWave Before You EMail Me. This page describes guidelines for sending me help requests by email. ShortFadeBar …
Empty A Folder
This page describes a procedure named EmptyFolder which you can use to delete the entire contents of a folder, but leave the folder intact. …
Ensure Macros Are Enabled
21 Jul 2007 … Pagebanner. ThreeWave Ensuring Macros Are Enabled. This page illustrates a technique to allow a workbook to function only if macros are …
Enable Macros, Method 2
16 Aug 2007 … Pagebanner. ThreeWave Ensuring Macros Are Enabled, Part 2. This page describes a second technique to allow a workbook to function properly …
Enum Variable Type
Pagebanner. ThreeWave Enum Variable Type. This page describes the Enum data type . ShortFadeBar. Introduction. An Enum (short for Enumerated) variable type …
Error Handling In VBA
From Pearson Software Consulting, your complete resource for Excel solutions.
Office EULA FAQ
The End User License Agreement (EULA) is the legally binding agreement between you, the user, and Microsoft regarding use of the programs in Microsoft …
Events In Excel VBA
20 Feb 2008 … Pagebanner. ThreeWave Events And Event Procedures In VBA. This page describes Events and Event Procedures in VB and/or VBA. ShortFadeBar …
Excel Formulas
Formulas. NOTE: This page is no longer updated. Most of the topics here are now covered on other pages, or have pages of their own. …
Excel Macros
Macros. NOTE: This page is no longer updated. Most of the topics here are now covered on other pages, or have pages of their own. However, I will leave this …
Excel Pages
19 Oct 2007 … Pagebanner. ThreeWave Excel Pages. This page describes the various pages on the web site. ShortFadeBar. This is the Page Index to the Excel …
Excel Pages
A list all all the pages in the Excel Web Source, the best source for information about Excel formulas, functions, and VBA programming..
Excel QA
Excel Q & A. NOTE: This page is no longer updated. Most of the topics here are now covered on other pages, or have pages of their own. …
Detecting When Excel Shuts Down
There is no built-in event or method to use to detect when the Excel application closes. You can use the BeforeClose event procedure to detect when a …
Pearson Software Consulting
25 Jun 2007 … Pagebanner. ThreeWave Site Feedback. You can use this form to send questions, comments, suggestions, errors etc. to the me. ShortFadeBar …
Feet And Inches
0
File Extensions In VBA
15 Mar 2008 … Pagebanner. ThreeWave File Extensions And Their Implications In VBA Coding. This page describes how the Windows Hide File Extensions setting …
Changing File Times With VBA
27 Aug 2008 … Neither Excel nor VBA provide a mechanism for retrieving or changing the file times of a file. The three file times are Create Time, …
FindAll VBA Function
24 Oct 2007 … Pagebanner. ThreeWave FindAll Function. This page describes VBA functions that can be used to find all the occurrences of a value on a …
First And Last Names
A frequent task many people encounter when working with lists of data in Excel is splitting full names into the first-name and last name components. …
Directory Tree Listings
Pagebanner. ThreeWave Folder Tree. This page describes VBA code to create a ” tree” listing of files and subfolder of a specified folder. ShortFadeBar …
Directory Tree Listings
17 Sep 2007 … Pagebanner. ThreeWave Folder Tree. This page describes VBA code to create a ” tree” listing of files and subfolder of a specified folder. …
Folder/File Tree View
Pagebanner. ThreeWave Creating A Folder/File Tree View. This page describes code used to create a Tree View representation of Folder And Files. ShortFadeBar …
GetSystemMessageText
Pagebanner. ThreeWave Getting System Error Message Text. This page contains VBA code to return a text description of a system error message. ShortFadeBar …
GetSystemMessageText
2 Nov 2008 … Pagebanner. ThreeWave Getting System Error Message Text. This page contains VBA code to return a text description of a system error message. …
Extending VBA UserForms
Pagebanner. ThreeWave Extending The Capabilities Of VBA UserForms With Windows API Functions. This page describes techniques you can use to extend the …
Form Positioner
Describes VBA procedures for positioning a VBA UserForm relative to a cell.
New Page 1
27 Aug 2008 … While many, if not most, users have the “Edit directly in cell” option turned on , and press F2 to edit the contents of a cell, …
Fractional Arithmetic
31 Jul 2008 … Pagebanner. ThreeWave Fractional Arithmetic In Excel. This page describes how to write formulas that support fractional arithmetic. …
Excel Games
30 Jun 2000 … A few games written in Excel and VBA. Play a game, and still have your boss thinging you’re working.
Get FileName
Pagebanner. ThreeWave Finding The Most Or Least Recent File In A Folder. This pages describes a VBA function that will return the name of the most recently …
GetInfo
From Pearson Software Consulting, your complete resource for Excel solutions.
Headers And Footers
You can use VBA code to create your own headers and footer. This can give you more flexibility than using the standard header and footer options from the …
Hidden Name Space
This page was written by Laurent Longre, and is included on my site at his request and with his kind permission. I have made some minor changes in …
Hints And Tips For New Users
15 Sep 2008 … Pagebanner. ThreeWave This page lists hints, tips, and guidelines for using the USENET newsgroups. ShortFadeBar. SectionBreak …
Holidays
A variety of formulas and VBA functions for working with holidays in Micrsoft Excel.
Importing Big Text Files Into Excel
Pagebanner. ThreeWave Importing Large Files In To Excel. This page describes VBA code to import large text files into Excel. ShortFadeBar. Introduction …
Exporting And Importing Text Into Excel
17 Nov 2007 … Pagebanner. ThreeWave Exporting And Import Text With Excel. This page describes how to import text files to Excel and how to export Excel …
Exporting And Importing Text Into Excel
17 Nov 2007 … Pagebanner. ThreeWave Exporting And Import Text With Excel. This page describes how to import text files to Excel and how to export Excel …
INDIRECT Function
The INDIRECT worksheet function is a useful tool for creating cell or range references “on the fly”, as a formula is evaluated, rather than “hard coding” …
Insert And Fill Series
This page describes a VBA procedure that you can use to insert rows or cells and fill in missing elements of a series of numbers. Suppose you have a partial …
Inserting Procedure Name
Pagebanner. ThreeWave Insert Procedure Names In VBA Code. This page describes how to use VBA code to insert procedure names into other VBA code. …
Installing An Add-In
Pagebanner. ThreeWave Installing An Add-In. This page describes how to install an XLA Add-In for Excel. ShortFadeBar. Adding A New Add-In …
IsArrayAllocated
Pagebanner. ThreeWave Is An Array Allocated? This page describes a VBA procedure you can use to determine whether a dynamic array or an array in a Variant …
CPearson.com Main Page
Pagebanner. ThreeWave Is An Array Sorted. This page describes procedures you can use to determine whether an array is in sorted order. ShortFadeBar …
Test If A File Is Open
Pagebanner. ThreeWave IsFileOpen. This page describes how to test whether a file is open. ShortFadeBar. Introduction. If your project works with files other …
Working With Visible Cells
4 Sep 2008 … Pagebanner. ThreeWave Working With Visible And Hidden Cells. This page describes how to work with visible and hidden cells. ShortFadeBar …
Julian Dates
Many applications (especially mainframe systems) store dates in the Julian format, which is a 5 digit number, consisting of a 2 digit year and a 3 digit …
KeyboardShortcuts
From Pearson Software Consulting, your complete resource for Excel solutions.
Testing Key States
Pagebanner. ThreeWave Testing Key States. This page describes VBA code to test the state of the SHIFT, CTRL, and ALT keys. ShortFadeBar. Introduction …
Testing Key States
5 Oct 2007 … Pagebanner. ThreeWave Testing Key States. This page describes VBA code to test the state of the SHIFT, CTRL, and ALT keys. ShortFadeBar …
Last Update Time Of Cell
NOTE: The CALL function was disabled one of the later Excel97 updates, and is not available in Excel2000 or 2002. The reason for this was that is presented …
Latitude And Longitude
This page contains a number of formulas for working with Latitudes and Longitudes in Microsoft Excel97 and Excel2000.
Legalese And Disclaimers
Pagebanner. ThreeWave Legal, Copyright, And Dislaimers For The Web Site. This page contains information about copyright matters. ShortFadeBar …
Excel Links
This page contains a variety of links to other pages which have useful information about Microsoft Excel. Also see the “Additional Resources For Excel …
List Box Utilities
This page describe a number of utility functions designed to make the MSForms ListBox control easier to use. You can download a bas module file or a …
List Functions
14 Jul 2007 … Pagebanner. ThreeWave List Functions. This page describes various formulas and VBA procedures for working with lists of data. ShortFadeBar …
Working With Lists
Excel is ideal for working with lists of data. This page describes a number of worksheet formulas for extracting basic information about a list — sums, …
Local And GMT Times
27 Aug 2008 … There is no built-in way to convert between a Local Time and Greenwich Mean Time (GMT, also called UTC or Zulu Time). …
Tables And Lookups
5 Jan 2008 … Pagebanner. ThreeWave Tables And Lookups. This page describes a number of formulas to return data from tables and formulas to look up data …
Make Multiple Directories
In VBA, you can use the MkDir function to create a new folder or subfolder. However, the folder in which that new folder is to be created must exist. …
Matrix To Vector
Pagebanner. ThreeWave Extracting Vectors From A Matrix. This page describes Excel worksheet formulas for extracting a vector from a matrix. ShortFadeBar …
Menus In Excel97 And 2000
This page describes how to create custom menu items in Excel, both manually and with VBA code.
Missing References In VBA
Pagebanner. ThreeWave Missing References In VBA. This page describes what to do if references in VBA cannot be found. ShortFadeBar. Introduction …
Modifying The System Registry
This page describes the steps you need to take to manually examine or modify the System Registry. For VB code that modifies the Registry, see the Functions …
Pearson Software Consulting
Pagebanner. ThreeWave Using Excel With Multiple Monitors. This page describes working with multiple monitors in Excel. ShortFadeBar …
Widen The Name Box
29 Jul 2007 … Pagebanner. ThreeWave Widen The Defined Name Box. This page describes how to widen the dropdown Defined Name box. ShortFadeBar. Introduction …
This page has been replaced. Click here to go to the new page.
This page has been replaced. Click here to go to the new page.
Name Box Shortcut
From Pearson Software Consulting, your complete resource for Excel solutions.
Named Ranges
This page describes how to use Named Ranges, or Defined Names, in Microsoft Excel97 and 2000. It also includes some advance techniques for defined names.
Nested IFs
A well known limitation to Excel is that you cannot “nest” more than 7 functions . For example, the following formula will fail because the limit is exceeded …
Suggestions For New Posters
This page as been replaced. Click here for the new page.
Eliminating Blank Cells From Lists
You can use a formula to return only the non-blank cells from a range. The following function will return all the cell values in a range named BlanksRange …
Untitled Page
Pagebanner. ThreeWave Page Topic. This page describes some facet of Excel Programming. ShortFadeBar. Introduction. This is some content text. SectionBreak …
Untitled Page
14 Jul 2007 … Pagebanner. ThreeWave Preventing Duplicates In Data Entry. This page describes how to use Data Validation to prevent duplicate data entry in …
Pearson Software Consulting
Pagebanner. ThreeWave Scheduling Events With OnTime And Windows Timers. This page describes the Application.OnTime method and Windows Timers. ShortFadeBar …
Pearson Software Consulting
Pagebanner. ThreeWave Scheduling Events With OnTime And Windows Timers. This page describes the Application.OnTime method and Windows Timers. ShortFadeBar …
Pearson Software Consulting
25 Jun 2007 … Pagebanner. ThreeWave Scheduling Events With OnTime And Windows Timers. This page describes the Application.OnTime method and Windows Timers …
Optimize VBA
This page contains a number of tips for optimizing your Excel/VBA code for Microsoft Excel 97 and 2000.
Optional Arguments To Procedures
29 Sep 2007 … Pagebanner. ThreeWave Optional Parameters To Procedures. This page describes two methods of implementing optional and a variable number of …
Ordinal Numbers
An ordinal number is a number that expresses position in a series, such as 1st, 2nd, or 3rd. Excel does not have a built in method for appending the suffix …
Working With Times Example Page
Learn about formulas for working with timesheets and overtime hours in Microsoft Excel97 and Excel2000.
Passing And Returning Arrays With Functions
In VBA, you can pass arrays to procedures (Subs, Functions, and Properties), and Functions and Properties (Property Get only) can return arrays as their …
Passwords
One of the more frequent questions in the newsgroups in what to do when a password has been lost. The following sites have products or add-in modules that …
Persistent Minimums And Maximums
18 Oct 2008 … Pagebanner. ThreeWave Persistent Minimums And Maximums. This page describes how to write formulas for persistent minimums and maximums using …
Parsing Telephone Numbers
Sample VBA Code for Microsoft Excel97 and 2000 to break out phone numbers into their components.
Introduction To Pivot Tables
An very quick introduction to Pivot Tables in Excel97 and 2000.
Allocated Pricing
This page describes formulas for Excel to work with allocated pricing amounts.
Testing For Prime Numbers
10 Oct 2008 … Pagebanner. ThreeWave Testing Prime Numbers In Excel. This page describes how to use a formula to test if a number if a Prime number or a …
Untitled Page
Pagebanner. ThreeWave Privacy Policy. This page describes the privacy policy at cpearson.com. ShortFadeBar. I take the issue of privacy on the internet very …
Progress Indictor
NOTE: There is a bug in the ProgressReporter DLL, so I have removed it from the web site until I can fix the bug. While a long procedure is executing, …
QSortObjectCompare Example Procedure
From Pearson Software Consulting, your complete resource for Excel solutions.
Random Numbers In Excel
11 Aug 2007 … Pagebanner. ThreeWave Random Numbers In Excel. This pages describes how to work with random numbers in Excel and VBA. ShortFadeBar …
Random Numbers In Excel
11 Aug 2007 … Pagebanner. ThreeWave Random Numbers In Excel. This pages describes how to work with random numbers in Excel and VBA. ShortFadeBar …
Using The Range Find Method In VBA
You can use VBA to find data in a range of cells using the Find method of a Range. Unfortunately, there is no FindAll method that will return a Range object …
Ranking Data In Lists
19 Sep 2007 … Pagebanner. ThreeWave Ranking Data In Lists. This page describes worksheet formulas you can use to work with data ranking in Excel …
Recursion And The FileSystemObject
This page introduces the concept of recursive procedures and uses the Scripting FileSystemObject as an example of when recursion can be a powerful …
Recursive Programming
14 Sep 2007 … Pagebanner. ThreeWave Recursive Programming. This page describes a programming technique called Recursive Programming, in which a procedure …
Recycle A File Or Folder
Pagebanner. ThreeWave Recycling A File Or Folder. This page describes VBA code to send a file or folder to the Windows Recycle Bin and to empty the Recycle …
Recycle A File Or Folder
20 Oct 2007 … Pagebanner. ThreeWave Recycling A File Or Folder. This page describes VBA code to send a file or folder to the Windows Recycle Bin and to …
VBA References
Often you will want to use VBA procedures in one workbook from another workbook. For example, you may have a useful financial function in an add-in and you …
Registry Functions
If you need to store information from one Excel session to the next, such as user preferences or application configuration data, you can store that data in …
RegistryWorx
Pagebanner. ThreeWave RegistryWorx Registry Access Component. This page describes the RegistryWorx ActiveX DLL that wraps up all the Windows API functions …
Relative And Absolute Range References
11 Oct 2008 … Pagebanner. ThreeWave Relative And Absolute References In Formulas. This page describes relative and absolute cell references in Excel …
Additional Resources For Excel Users
As you becomes more and more experienced with Excel and VBA programming, you will find that you have more and more questions, especially as you start …
Returning Arrays From VBA Functions
6 Nov 2007 … Pagebanner. ThreeWave Returning Arrays From VBA User Defined Functions. This page describes returning arrays as the result of VBA User …
Returning Arrays From VBA Functions
6 Nov 2007 … Pagebanner. ThreeWave Returning Arrays From VBA User Defined Functions. This page describes returning arrays as the result of VBA User …
Rounding And Precision In Excel
You can download this article as either a Word97 or RTF file. This articles applies to all versions of Microsoft Excel For Windows. …
RowLiner Add-In
Introduction. The RowLiner add-in allows you have Excel automatically draw row and/or column lines around the active cell, making it easier to view rows and …
Untitled Page
Pagebanner. ThreeWave Page Topic. This page describes some facet of Excel Programming. ShortFadeBar. Introduction. This is some content text. SectionBreak …
SaveCopyAndZip Add-In
This page describes the SaveCopyAndZip XLA add-in. This add-in lets you save a copy of any open workbook as a Zip file. The add-in does a SaveCopyAs rather …
Understaning Scope
Pagebanner. ThreeWave Scope Of Variables And Procedures. This page describes what it meant by the Scope of a variable or procedure. ShortFadeBar …
Search
Serach the Excel Web Source web site. From Pearson Software Consulting, your complete resource for Excel solutions.
Testing Series Content
13 Jul 2007 … Pagebanner. ThreeWave Information About Series Of Numbers. This page describes a few VBA methods for working with a series of numbers. …
Pearson Software Consulting
27 Jun 2007 … Pagebanner. ThreeWave Userforms And The SetParent Function. This page describes how to use the SetParent API function to control how …
Referencing Worksheets From Formulas
Excel allows you to refer to cells on other worksheets, but these links are not relative; there is no way to refer to the next or previous sheet without …
Shell And Wait
9 Sep 2008 … Pagebanner. ThreeWave Shell And Wait. This pages describes the VBA Shell function and provides a procedure that will wait for a Shell’d …
Shortcut Keys In Excel
23 Oct 2007 … Pagebanner. ThreeWave Shortcut Keys In Excel And VBA. This page provides links to pages regarding shortcut keys in Excel and VBA. …
Show Any Form
In VBA, the usual way to show a form is to simply use the Show method. However, this method requires that you hard-code the UserForm’s name in your code. …
Shuffle Array
31 Jul 2008 … Pagebanner. ThreeWave Shuffle Array. This page describes code to shuffle an array into random order. ShortFadeBar. SectionBreak …
Web Site Stats
1 Nov 2008 … Pagebanner. ThreeWave Site Statistics. This page presents some of the usage statistics of the CPearson web site. ShortFadeBar. SectionBreak …
Fixed Length Strings In VBA
From Pearson Software Consulting, your complete resource for Excel solutions.
SortByColor
If you have color-code cells in your worksheet, you find that at times it is useful to sort rows by the colors of the cells. That is, sort all the reds at …
Sorting Arrays In VBA
28 Oct 2008 … Pagebanner. ThreeWave Sorting Array In VBA. This page describes procedures for sorting arrays of values in VBA. ShortFadeBar. SectionBreak …
Sorting Arrays Of Objects
The QSortInPlace procedure described on the Sorting Arrays With QSort page will sort arrays of simple data types (e.g. Strings, Integers, Longs, Singles, …
Sorting And Ordering Worksheets
Pagebanner. ThreeWave Sorting And Ordering Worksheets In A Workbook. This page describes VBA procedures you can use to sort or order worksheets within a …
Sorting And Ordering Worksheets
22 Sep 2007 … Pagebanner. ThreeWave Sorting And Ordering Worksheets In A Workbook. This page describes VBA procedures you can use to sort or order …
Retrieving User Specific Folders
Pagebanner. ThreeWave Retrieving User’s Special Folders. This page describes VBA code that you can use to retrieve a user’s special folders. ShortFadeBar …
Split On Delimiters
20 Sep 2007 … Pagebanner. ThreeWave Split Text On Multiple Delimiters. This page describes two functions that are logical extensions of the VBA SPLIT …
Startup Errors In Excel
31 Oct 2007 … Pagebanner. ThreeWave Startup Errors In Excel. This page describes how to diagnose and fix errors that may occur during start up. …
Status Bar
This page contains VBA procedures for working with the Status Bar in Microsoft Excel97 and Excel2000.
String Concatenation
19 Oct 2007 … Pagebanner. ThreeWave String Concatenation. This page describes a VBA Function that you can use to concatenate string values in an array …
String Formulas
2 Nov 2007 … Pagebanner. ThreeWave Formulas For Working With Strings. This page describes some formulas for working with text strings. ShortFadeBar …
SubClassing With The SSubTmr6 DLL
This page describes how to use the SSubTmr6 DLL in your VBA projects to implement subclassing. Other pages on this site describe how to use subclassing in …
Getting Support
If you’re new to Excel, and even if you’re not, you may have questions about Excel. In addition to the web sites on my Links page, there are several ways to …
Suppressing Events In UserForms
In most VBA code, you can use the Application.EnableEvents property to prevent Excel from calling event procedures. This often used in the Change event of a …
Table To Column
Pagebanner. ThreeWave Converting A Table To A Column. This page describes formulas and VBA code you can use to convert a two-dimensional table to a single …
Restricting Entry In TextBox
If you are using a VBA Userform, you are almost surely using the TextBox control , and in many of these circumstances you may wish to restrict what sort of …
New Page 1
27 Aug 2008 … You may find that your application should close a file if there has been no user activity on that workbook for a specified period of time. …
Untitled Page
6 May 2008 … Pagebanner. ThreeWave Time Zones And Daylight Savings Time. This page describes code for working with Time Zones and Daylight Savings Time. …
Untitled Page
Pagebanner. ThreeWave Time Zones And Daylight Savings Time. This page describes code for working with Time Zones and Daylight Savings Time. ShortFadeBar …
CPearson.com Topic Index
Pagebanner. ThreeWave Site Topic Index. This page lists the topics covered on the web site. ShortFadeBar. This page lists all the various topics covered on …
CPearson.com Topic Index
8 Sep 2007 … Pagebanner. ThreeWave Site Topic Index. This page lists the topics covered on the web site. ShortFadeBar …
Truly Global Variables With SetGetProp
Excel supports “global” variables only at the workbook level. If you declare a variable using the Public declaration in a standard code module, …
Unselect A Range
Pagebanner. ThreeWave Unselecting A Cell Or Area. This page describes that you can use to remove the active cell or the active area from the selection. …
Code Usage And Distribution
Pagebanner. Code Distribution Guidelines. I take a rather liberal stand on the issue of code usage and distribution. You are free to use any code and …
Cell Values And Displayed Text
When you are working in Excel, either with formulas or with Visual Basic For Applications (VBA) code, it is important to understand the difference between …
VBA Arrays
From Pearson Software Consulting, your complete resource for Excel solutions.
VBA Shortcut Keys
NOTE: The key assignments listed here are for standard US-English keyboards. Key mappings on non-US-English keyboards are slightly different. …
Programming In The VBA Editor
Pagebanner. ThreeWave Programming The VBA Editor. This page describes how to write code that modifies or reads other VBA code. ShortFadeBar. Introduction …
Programming In The VBA Editor
18 Oct 2007 … Pagebanner. ThreeWave Programming The VBA Editor. This page describes how to write code that modifies or reads other VBA code. ShortFadeBar …
Creating Menus For The VBA Editor
3 Sep 2007 … Pagebanner. ThreeWave Creating Menu Items In The VBA Editor. This page describes how to create menu items in the VBA Editor. ShortFadeBar …
Creating Menus For The VBA Editor
3 Sep 2007 … Pagebanner. ThreeWave Creating Menu Items In The VBA Editor. This page describes how to create menu items in the VBA Editor. ShortFadeBar …
Excel Versions
1 Dec 2001 … This page describes the general differences between various recent versions if Microsoft Excel. It is not a comprehensive list of changes, …
Wait For File Close
From Pearson Software Consulting, your complete resource for Excel solutions.
Week Numbers In Excel
Working with Week Numbers In Microsoft Excel97 and 2000. Includes both worksheet formulas and VBA code procedures.
Pearson Software Consulting
Pagebanner. ThreeWave What’s New On The Site. This page is a chronological listing of updates to the web site, from 1998 through the present. ShortFadeBar …
Who The Hell Is Chip?
Several of you Excel aficionados have asked me the same question: Just who the hell are you? And why do you answer do many questions on the Excel newsgroups …
Word Count
From Pearson Software Consulting, your complete resource for Excel solutions.
Workbook Command Bar
Pagebanner. ThreeWave Workbook Display Command Bar. This page describes the Workbook Command Bar COM Add-In. ShortFadeBar. Introduction …
Timebombing A Workbook
11 Oct 2007 … Pagebanner. ThreeWave Timebombing A Workbook. This page describes how to limit the functionality of a workbook after a period of time. …
Temporary Files And Folders
This module contains three procedures related to temporary files and folders. The first procedure, GetTempFolderName , returns the name of the folder that …
Writing Your Own Functions In VBA
1 Sep 2007 … Pagebanner. ThreeWave Writing Your Own Functions In VBA. This page describes how to write your own worksheet functions in VBA. ShortFadeBar …
Tools For Excel
Add-in programs to make Excel97 and 2000 easier to use.
Zooming And Centering On A Range
This page describes two VBA procedures that you can use to zoom in on a specific range of a worksheet, or to center the screen on a specific cell. …
Page Not Found
Pagebanner. ThreeWave Page Not Found. The requested page was not found. ShortFadeBar. Requested Page: /Newsletter/AdvertiseHere.aspx …
CPearson Newsletter Archive
Pagebanner. ThreeWave CPearson Newsletter Archive. This page lists previous versions of the CPearson Excel Newsletter. ShortFadeBar …
Newsletter Redirect
Pagebanner. ThreeWave Newsletter Redirect. This is a redirect page to the primary newsletter page. ShortFadeBar. The Newsletter page has been moved. …

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: