Site Topic Index

This page lists the topics covered on the web site.

This page lists all the various topics covered on the web site. If you find a mistake or bad link, please use the Feedback page to let me know.

A Absolute And Relative Cell References Activating Excel From Other Applications ActiveCell, Highlighting Add-Ins, Automation, Creating Add-Ins, COM, Creating With VB6 Add-Ins, Creating Add-Ins, Installing And Loading Add-Ins And Utilities, Third Party Age, Calculating ALT, SHIFT, and CTRL Testing State Of Key Analysis Tool Pack (ATP), Installing Analysis Tool Pack, Calling Function From VBA AnyXML, Allowing optional and arbitrary XML content with an XSD Schema API Functions, Getting Error Information Application Events Application Shutdown, Detecting And Taking Action Application-Level Names Arguments, Passing ByVal And ByRef Array Formulas, Described Array, Converting To Columns Array, Testing If Allocated Array, Testing If Sorted Arrays, Determining Data Type Of Arrays, Number Of Dimensions Arrays, Passing To Procedures And Returning From Functions Arrays, Randomizing (Shuffling) Order Of Elements Arrays, Returning From User Defined Functions Arrays, VBA Function Library (30 procedures) Arrays, Reversing Arrays, Sorting Arrays Of Objects, Sorting Arrays, Utility Procedures For Attachments In Newsgroups, Why Not Attributes, Descriptions To Display In Object Browser Automatically Closing A Workbook After Idle Time Automation Add-Ins And Function Libraries Automation Add-In And Function Libraries With NET Averages, Weighted Averaging Values In A Range Averaging Highest Or Lowest Values B Banding, Color Banding With Conditional Formatting Banding, Content Based Banding Birthdays And Age Bitness, 32-Bit And 64-Bit Excel Blank Cells, Eliminating Blank Rows, Deleting Blinking Text Bracket Pricing, Formulas For Browse For Folder Built-In Document Properties Button Image, Custom Pictures ByRef and ByVal Parameter Passing C CALL Worksheet Function Caption of a Window and the Hide Extensions setting Case, Converting Text To Upper or Lower Case Cell Contents, Displaying Hidden Characters Cell References, Absolute And Relative Cell Values And Displayed Text Cell, Last Cell In A Range Cells, Referring To Cells In Another Range CellView Add-In Centering The Screen On A Range Of Cells Character Tests For Strings Characters, Counting In A String Characters, Finding In A String Characters, Special characters in Excel Child Windows with UserForms Circular References, Example Class Modules Class Instances, Self-referencing Class Names, Window Class Name Of Office Applications Classes, Default Member Of Clipboard, Windows Cloning A Folder Close, Detecting And Taking Action When Excel Closes Closing A Workbook Automatically After Idle Time Code Modules Code And Formula Usage, Legal Considerations CodeName property CodeName, Using To Prevent Run Time Errors Code Modules Code, Where to put it and how to use it. Collections And Dictionaries, Procedures for, Sorting Colors, Counting And Summing Cells Based On Font or Interior Color Colors, RGB Values Color Picker, Displaying A Color Picker To The User Colors, Sorting By Color Banding With Conditional Formatting Column To Table Conversion Column To Matrix Formulas Column To Table Conversion, Variable Block Size Column Or Row From Table Conversion COM Add-Ins, Getting The DLL Name Of COM Add-Ins, Creating With VB6 COM Add-Ins, Adding Menu Item For Dialog COM Add-Ins, Installer COM Add-Ins And Automation Add-Ins, Installing COM Add-Ins In Excel 2007 Concatenating Strings, a better method than CONCATENATE Conditional Formatting Command Bar Images, Custom Pictures Conditional Formatting,Using Cells On Other Sheets Conditional Formatting, Determining If Active Connected And Disconnected Object Variables Converting A Column To A Table Converting A Table To A Column Or Row CTRL, SHIFT and ALT, Testing State Of Key Copyright And Trademark Usage of contents of this site Counting Cells Based On Font Or Interior Color Counting Cells With A Specific Content Type Counting Values Between Two Numbers COUNTIF with multiple criteria Counting Characters In A String Counting Words In A Cell Or On A Worksheet CSV Files, Importing Files With More Than 64K Records Custom Document Properties, Reading And Writing In Open And Closed Files D Data Validation, Using Cells On Other Sheets Date Functions, Common And Useful Date Intervals, Formulas For Dates, Adding And Subtracting Dates, Differences Between Dates, Distributing Across Months Or Years Dates, Excel Serial Format Date, File Date And Times, Returning and Setting Dates, Finding With VBA .Find Method Dates, Quick Entry Dates, Two Digit Years Day Of Week, Returning Nth, Day Of Week In A Month (VBA) Day Of Week, Returning Daylight Savings Time Daylight Savings TIme Full Version Daylight Savings Time And Time Zones Day Of Week In A Month Days Between Dates, A Better NETWORKDAYS Days In Month, First And Last Days In Month DATEDIF Function Days Of The Week Functions, Formulas and VBA Debugging VBA Code Declaring Variables In VBA Declaring Using Option Explicit Default Member Of A Class Defined Names In Excel Defined Name Shortcut Keystroke Degrees, Minutes, And Seconds Deleting Blank Rows Deleting Duplicate Rows Deleting Duplicate Rows With Advanced Filter Deleting Contents Of A Folder Deleting A File Or Folder Deleting VBA Code Delimited Text, Extracting Elements Desktop, Getting Folder Name Of Diagonal Elements Of A Range, Summing Dictionaries And Collections, Procedures for, Sorting Directories, User Specific Directories, Creating A Tree List Directories, Creating Subdirectories DirTree Add-in Directory Listing, Quick And Easy Distributation And Usage Of Code And Formulas Distinct Elements In A Range Distinct Items In Lists Distinct Items In Lists Distinct Values VBA Functions, Returns Array Of Distinct Values DLL, Error Codes From Windows DLLs DLL Name Of A COM AddIn Document Properties, Reading And Modifying With VBA Download Files From The Internet Downloads Duplicate Items In Lists Document Properties, Reading Modifying In Both Open And Closed Files Duplicating A Folder Duplicate Entries, Highlighting Duplicate Entries, Preventing Duplicate Entries, Replacing Dynamic Ranges E Easter, Calculation Of Date Element Common To Two Lists Emptying A Folder Enum Data Type Ensuring Macros Are Enabled, Technique 1 Ensuring Macris Are Enabled, Technique 2 End User License Agreement (EULA) Err.LastDllError property Errors, Diagnosing Startup Errors Error Handling Errors, Returning From User Defined Functions Error Text From Windows API Functions Events In VBA, Repsonding To And Creating Events Events, Application Events, Suppressing In UserForms Every Nth Row, Getting Data From A Column Exporting Data To Text Files Exporting VBA Code To Text Files Exporting data to a fixed field width text file. Extension, File extensions and the Hide Extensions setting F FAQ (Frequently Asked Questions), Formal Feet And Inches Feet And Inches, Arithmetic With File Attachments In Newsgroups, Why Not File, Testing If A File Is Open File extensions and the Hide Extensions setting File Times, Retrieving and Setting File Names, Returning By Formula File Name, Returning Most Or Leaset Recently Modified In A Folder File Names, shortening with PathCompactPathEx File Names In Window Captions Files, Waiting For Open Files To Be Closed FileSystemObject, Creating A Directory Tree Filling A Series Of Data And Inserting Cells Finding Cells In VBA, Including WildCard Matching FindAll Function to search a range FindAll XLA Add-In Finding Values On Multiple Worksheets FindWindowEx, Captions, and the Hide Extensions setting First And Last Names, Extracting From A String Fixed field length text files, exporting to Fixed Length Strings Fixed Length Strings, Testing For Flexible Lookups, An Alternative To VLOOKUP Flickering, Screen Flickering When Code To The VBE Flipping Or Reversing A Range With VBA Floating Point Numbers Focus, Keeping Focus On The Worsheet Folder, Browse For Folder, Deleting Contents Folder, Creating An Exact Copy Folders, Creating Subfolders Folders, Creating A Tree List Of Subfolders And Files Folders And Files In A TreeView Control Folders, Returning User Specific Folders Folder Tree Listing, Quick And Easy Footers And Headers Footers And Headers (VBA code to customize) FormatMessage, Getting API Error Messages Forms, Positioning To Cells Forms, Moving With Windows Forms, Showing A UserForm Determined At Run-time Formula Bar, Shortcut To Fractional Arithmetic Fractional Months, Calculating Functions, User Defined, Determine Whence It Was Called Function Libraries As Automation Add Ins Function Libraries Written In NET Functions, As Opposed To Macros Functions, Writing Your Own Function In VBA Functions, Using Worksheet Functions In VBA G Games For Excel GetInfo UDF Getting Help From Newsgrops GetLastError Windows API Function GetSystemErrorMessageText Function Global Variables, Application-wide Global Variables Globally Unique Identifiers (GUIDs) GMT And Local Times, And Windows Time Formats Grades Great Circle Distances H Headers And Footers Headers And Footers (VBA code to customize) Hidden And Visible Cells, Functions For Hidden Name Space Hide Extensions setting and VBA in Excel High And Low Values, Persistent Highlighting ActiveCell HLOOKUP - A Better Way Holidays, Calculation Of Dates I IF Functions, Nested Importing Text Files Importing Text Files With More Than 64K Records Inches And Feet, Arithmetic With INDIRECT Worksheet Function Inserting Cells And Filling A Series Of Data Internet, Downloading a file from. Intervals, Dates IsFileOpen, Testing If A File Is Open ISO Week Numbers and Excel J Julian Dates K Keyboard Shortcuts Key State, Testing For SHIFT, CTRL, and ALT L Last non-empty cell in a range Last And First Names, Extracting From A String Last Modified File, Finding In A Folder Last Update Time Of Cell Or Range Latitude And Longitude Leap Year, Determining Least Or Most Common Entry In A List Legal Information About This Site And Its Contents Linked List Boxes Listboxes, Linked ListBox, Support Procedures For A ListBox control Lists, Counting Distinct Entries Lists, Extracting Unique Entries Lists, Entries Common To Two Lists Lists, Entries On One List And Not On Another Lists, Highlighting Duplicate Entries Lists, Merging Without Duplicates Distinct Lists, Getting Distinct Elements Lists, Testing For Duplicate Entries Lists, Reversing and Transposing Lists, Minimum And Maximum Values Lookups, Left Lookup (alternative to VLOOKUP) Lookups, Formula To Look Up Data In A Table Lookups, Flexible. Alternative To VLOOKUP Lower Case, Converting Text To Lower Case M Macro-Sheet Function, Calling From Worksheet Cell Macros, Adding or Deleting With VBA Code Macros, As Opposed To Functions Macros, Ensuring Macros Are Enabled, Technique 1 (Sheet Visibility) Macros, Ensuring Macros Are Enabled, Technique 2 (Calculations With Errors) Macros, Running From Worksheet Cell Matrix To Vector Formulas Maximum Values, Persistent Me Reference, Self-referencing an instance of a class Menu Items, Creating Manually Menu Items, Creating With VBA Code Menu Items, Creating For The VBA Editor Merging Lists Without Duplicates Minimum And Maximum Values Minimum And Maximum Values, Persistent Missing References In A VBA Project Modified File, Returning The Most Or Least Recently Modified File In A Folder Modules, Adding And Deleting With Code Modules, Adding descriptions for the Object Browser Months, Calculating Fractional Months Most Or Least Common Entry In A List Moving A Form With The Window Multiple Directories, Creating Multiple Monitors My Documents Folder, Finding For The Current User N Named Ranges Named Range Box, Increase The Size Of Named Range Box, Shortcut Keystroke Nested Function, Exceeding Limit NET Function Libraries NETWORKDAYS, A Better Way Newsgroups, Connecting To Newsgroups, Excel Related Newsgroups, Hints For New Posters Newsgroups, Problems Posting To Next And Previous Worksheets Non-blank Cells, Returning From Range Non-duplicate Random Numbers O Objects, Declaring Objects, Sorting Arrays Of Objects Objects, Connected And Disconnected OnTime Method In VBA On Error handling Optimizing VBA Code Optional Parameters To A Function Optional And Arbitrary XML defined in an XSD Schema Option Explicit Order, Reversing Cell Ordinal Numbers In Excel Overtime Hours In Timesheets

P ParamArray parameters to a VB Function Parameters, Passing ByRef And ByVal Parameters, Optional Parameters To A Function Passing Parameters ByRef And ByVal Parent Windows, With Userforms Passing And Returning Arrays From Procedures Passwords, Forgotten PathCompactPathEx API Function Pause Code For User Input Pause Code Execution Phone Numbers, Parsing Pictures On Command Bar Items, Custom Pivot Tables, An Introduction Positioning UserForms To Cells Preventing Duplicate Entry Previous And Next Worksheets Printing Cell Comments To Word Printing Multiple Worksheets Pricing, Progressive And Bracket Prime Numbers And Prime Twins, Testing A Number Printing Cell Formulas To Word Procedure Attributes For The Object Browser Procedure Name, Automatically Inserting Into Procedure with CONST declarations Procedures, Scope And Visibility Progress Bar, Displaying while running code Proper Case, Converting Text To Proper Case Properties, Document: Using With VBA Q Quarter, Determining From Date QSort, Sorting Arrays Of Variables QSort, Sorting Arrays Of Objects QSortObjectCompare Example Function R Random Numbers In Excel And VBA Randomize The Order Of Elements In An Array Ranges, Converting To Column Ranges, Referring To Cells In Another Range Ranking Data In List (and associated topics) Recursive Code, Example Of Recursive Programming Techniques Recursive Code, Illustrated With The File System Object Recycle Bin Recycling A File Or Folder Recycling The Contents Of A Folder References, Setting To VB Projects References, Missing References In A VBA Project Registry, Functions For Working With The Registry RegistryWorx DLL Registry Component Relative worksheet addressing Renaming Worksheets, Avoiding VBA Problems Returning Every Nth Value In A Range Relative And Absolute Cell References Returning Arrays From User-Defined Functions Reversing A Range Of Cells Reversing An Array Rounding Errors And Precision Rounding Times Row To Matrix Formulas RowLiner Cell Highlighting Add In Rows, Deleting Blank Rows, Deleting Duplicate Row, Returning a table into a single row RSS Feed, Get What's New Information via an RSS Feed S Save Copy And Zip - XLA Add-In Save Copy And Zip - COM Add-In Scheduling Procedures With OnTime Scope Of Variables And Procedures Screen Flicker When Programming To The VBA Editor Scrolling To Center A Range Scrolling, Detecting With VBA Self-Referencing an instance of a class using "Me" Selecting Current Array Selecting Current Named Range Selection, Saving And Returning To Sequence Selection, Removing Active Cell Or Active Area Series, Inserting Cells And Filling A Series Series, Finding A Series Of Cells That Sums To A Number Series, Testing Whether Values Are In Correct Series Order Series, Testing Missing And Present Black Of Numbers SetFocus, Keeping Focus On The Worsheet SetParent Function For UserForms Shading Cells Sheet Name, Returning Sheet Names, Returning (VBA) Sheet Names, Returning By Formula Shell Command, ShellAndWait SHIFT, CTRL, and ALT, Testing State Of Key Shortcut Keys ShortenTextToChars Function Shortcut Keys Shuffling Order Of Elements In An Array Shutdown, Detecting And Acting When Excel Shuts Down 64-Bit And 32-Bit Excel SizeString Function Sorted, Testing If An Array Is Sorted Sorting By Cell Color Sorting Arrays Sorting Arrays Of Objects Sorting Collections And Dictionaries Sorting Worksheets Sounds, Playing Sounds From VBA Special Characters In Cells, Displaying Hidden Characters Special Folders, Returning Names Of Split Function, A Better Way SplitEx Function Standard Time And Daylight Savings Time Startup Errors In Excel Status Bar, Working With In VBA Strings, Most Or Least Common In A Range Strings, Concatenating With Ranges And Arrays Strings, Counting Characters In Strings, Finding Characters Or Digits Strings, Fixed Length Strings, Testing For Fixed Length Strings, Shortening With PathCompactPathEx Strings, General Formulas SubClassing The ActiveWindow Subfolders and Subdirectories, Creating SUMIF, Multiple Criteria Summing Cells Based On Font Or Interior Color Summing Every Nth Value Support, Getting Support For Excel Symbols, Using special symbols with Excel T Tables, Lookup Functions For Tables Table, Converting To Row Or Column Table, Creating A Table From A Column, Variable Block Size Telephone Numbers, Parsing Temporary Files And Folders Text Files, Importing And Exporting Text Files, Importing Files With More Than 64K Records Text Vs Value, Formulas And VBA Text File, Importing And Exporting TextBox, Resricting to numeric-only input Thanksgiving, Calculation Of Date 32-Bit And 64-Bit Excel "This" reference is "Me" in VB/VBA TimeBombing A Workbook Timed Closing Of A Workbook Timers, Scheduling Procedures Times, Adding And Subtracting Times, Daylight Savings And Standard Times And Working Hours, Between Two Dates Times, Quick Entry Times, Rounding Timesheets, Working With Regular And Overtime Hours Time Zones Time Zones And Daylight Savings Time Timers In Excel Tools For Excel (Free Add-ins) Tracking Workbook Opens And Closes TreeView Control, Using To Display Folders And Files TrimToChar Function TrimToNull Function Transposing A Range With Formulas U Union Method, A Better Way Unique Entries, Counting Unique Identifiers (GUIDs) Unique Ranks Unique Random Numbers Unique Values In A Range, VBA Function To Return Disinct Items UnSelecting A Cell Or Area Upper Case, Converting Text To Upper Case Usage And Distribution Of Code And Formulas User Defined Functions (UDFs) In VBA User Defined Functions, Determine Whence It Was Called User Defined Functions, Returning Arrays User Defined Functions, Returning Errors Userforms: Keeping focus on the worksheet. Used Cells In A Range User-Specific Folders UserForm Events, Suppressing UserForms, Modifying With Windows API Functions UserForms, Parent And Child Windows UserForms, Positioning To Cells UserForms, Showing A UserFrom Determined At Run-time UTC And Local Times, And Windows Time Formats Utilities and Add-Ins, Third Party V Variables In VBA, Declaring Variables, Scope And Visibility Variables, Truly Global Variables In VBA VBA Editor, Automating The VBA Editor and its objects VBA Editor, Creating Menus For The VBA Editor VBA Project, Missing References In A VBA Project Vectors And Matrices Versions Of Excel Visible And Hidden Cells, Functions For Visual Basic For Applications (VBA), Optimizing VLOOKUP - A Better Way VBA Code, Adding/Deleting Modules W Wait For File To Be Closed Wait For User Input In VBA WAV files, playing from VBA Week, First Monday Of Week Numbers Weekday, Counting Between Dates Weekday, First And Last Of Month Week Days, Formulas and VBA Weekday, Nth Day Of Month Weekdays, Creating Series Of Weeks, Difference Between Dates Weighed Averages Where to put code and how to use it. Wildcard Matching With Find Window captions and the Hide Extensions setting Window Captions, Putting The File Name In the Caption Windows API Functions, Getting Error Information Window Class Names Of Office Applications Words, Counting In A Cell Or On A Worksheet Words, Extracting From A String Workbook And Worksheet Names, Returning By Formula Workbooks, Closing All Workbooks, Creating list of names. Workbooks, Saving All Workbooks, Tracking Open And Close Operations WORKDAY function, A better way Worksheets, Creating list of names. Worksheet And Workbook Names, Returning By Formula Worksheet Functions, Using In VBA Worksheets, Printing Mulitple Sheets Worksheets, Referencing From Formulas Worksheets, Sorting X XLA Add-Ins, Creating XLA Add-Ins, Installing And Loading XML, Optional And Arbitrary XML defined in an XSD Schema X-Ray (Excel Game download) Y Year, First Monday Of Years, Entering Two Digit Years Z Zero Values, Ignoring In Functions Zip File, Saving A Workbook As A Zip File Zip File, Save As, COM Add-In Zooming On A Range Of Cells

This page last updated: 20-April-2010.

Bandwidth charges handled by this web hosting guide.

Created by Chip Pearson at Pearson Software Consulting, LLC
Email: chip@cpearson.com Before emailing me, please read this page. 
http://www.cpearson.com/Excel/Topic.aspx
Copyright © 1997 - 2011, Charles H. Pearson

Submit bug information or errors on the Bug And Error Report Page.



About This Web Site Activate The Main Excel Window Adding Dates Adding The COM Add-Ins Menu Item Adding the COM Add-Ins menu item Alerter Display Library Alerter Message Display Component Analysis ToolPak Application Events Array Formulas Array Formulas Arrays In VBA Arrays To Columns Attachments In Newsgroups Automation Add-Ins Blinking Text Blinking Text Bracket Pricing Browse Folder CALL Function Call Stack Calling Worksheet Functions Cell Referencing Cell View Add-In Class Modules Clipboard Functions Clone A Folder Code Modules Code Notes Collections And Dictionaries Color Band Formatting Colors And Functions COM Add-Ins In VB6 Conditional Formatting Conditional Formatting Colors Connected And Disconnected Objects Consulting And Development Services Creating An Add-In Date And Time Quick Entry Date And Time VBA Functions Date And Time Worksheet Functions Date And Times In Excel Date Arithmetic Date Intervals DATEDIF Function Dates And Times Daylight Savings Time Debugging VBA Declaring Variables Default Property Of A Class Deleting Duplicates Deleting Duplicates With Filter Detecting Scrolling Direct Connect The MSNEWS Directory Tree Listings Distributed Dates Document Properties Downloadable Files Downloadable Zip Files Downloads Duplicate Data In Lists And Ranges Duplicates In Lists Email Me Emailing ME Empty A Folder Enum Data Types Error Handling In VBA Error Values And The FormatMessage API EULA Answers Event Procedures Events In UserForms Excel Macros Excel Pages Excel Shutdown Excel Tools Excel Worksheet Functions Feet And Inches File Name Of COM Add-In File Times Find In Range First And Last Names Folder Tree Listing Folder Tree Listing Form Positioner Formula Bar Shortcut Fractional Arithmetic Functions And Subs Games Get And Set Properties GetInfo Function Headers And Footers Hidden Namespace Holidays Import And Export Text Importing Large Files To Excel Importing Large Text Files INDIRECT Function Insert And Fill A Series Insert Procedure Names In VBA Intro To VBA Julian Dates Keyboard Shortcuts Keyboard Tests Last Time Of File Latitude And Longitude Legalese Legalese and Copyright Information Links List Lookups ListBox Utlities Lists Of Data In Excel Lists On Worksheets Local And GMT Times Main Page Main Page Make Mulitple Levels Of Directories Menu Items Menus In The VBA Editor Modifying The Registry Multi File Import In VBA Multiple Monitors And Windows Name Box Shortcut Named Ranges Nested Functions New Posters Guide For Newsgroups No Blanks No Dupicate Entries Office Application Window Classes Optimize Your VBA Code Ordinal Number Suffixes Overtime And Timesheets Parsing Phone Numbers Passing And Returning Arrays In VBA Passwords Pivot Tables Popup Box Privacy Statement Progress Bar Random Numbers Ranking Data Recursive Programming Recycle A File Or Folder References Registry Related Pages Relative And Absolute References Relative And Absolute References Resources For Developers Returning Arrays Rounding In Excel Rowliner Add-In Save Copy And Zip A Workbook Save Coy And Zip Add-In Scheduling Procedures With OnTime Search The Site Search The Site Series Information SetParent And Userforms Sheet Referencing Shell And Wait Shortcut Keys Shortcut Keys For VBA Show Any Form Site Feedback Size String Some Friendly Sort And Array In VBA Sort By Color Sort Worksheet Tabs Sorting Arrays Of Objects Sorting Objects Comparison Special Characters Special User Folders Startup Errors In Excel Status Bar In Excel Subclassing Windows Support Suppress Changes In Forms System Error Messages From Numbers Temporary Files And Folders Test Friendly Text Box Validation Time Zones Timed Close Topic Index Truly Global Variables Unselect A Cell Or Area Upper And Lower Case User Defined Functions User Defined Functions Validate A Text Box Values And Formulas Variables In VBA VBA Code To Modify VBA Code Versions Of Excel Wait For File Close Week Numbers What's New On The Site Widen The Name Box Word Count Of Worksheet Zomming And Centering  
0 - Rate This Page 1 - Not Helpful 2 - Somewhat Helpful 3 - Quite Helpful 4 - Very Helpful 5 - Exactly What I Needed

Essential Tools For Developers




Essential Tools For Financial Analysts And Accounting Professionals

  
Ready


Advertise Your Product On This Site