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. … |
