Miscellaneous Programming Tips
- Using "Strong Arm" Tactics in Excel
Some things to consider if you attempt to control the users of your application - Ensuring that Data Validation is Not Deleted
A method to prevent users from deleting Data Validation rules. - Is Access to the VB Project Allowed?
How to determine the value of Excel 2002's "Trust access to Visual Basic Project" setting. - Creating a Usage Log
A simple VBA procedure that keeps track of when a workbook was opened - Mail Merge - Without Word
How to generate personalized letters using Excel. - Clearing the Advanced Filter Dialog Box
A simple VBA procedure that causes Excel to "forget" the previous range specifications for Advanced Filtering. - Sending Personalized Email from Excel
VBA code to send email messages from Excel. This code works with Outlook Express, and may or may not work with other email clients. - Pausing a Macro to Get a User-Selected Range
VBA code to pause a macro to let the user select a range. - Handling the Workbook BeforeClose Event
How to prevent your Workbook BeforeClose event code from running if the user changes his mind about closing the workbook. - Synchronizing Sheets in a Workbook
A VBA subroutine that forces all sheets in workbook to have the same range selection and upper left cell as the active sheet. - Help Context IDs for Excel 97, 2000, and 2002
Download workbooks that list the context IDs for Excel main help file. This makes it possible for your application to display a particular help topic via a macro. - Automatically Resetting the Last Cell
A simple procedure that forces Excel to keep track of the last non-empty cell in a worksheet. - Using Auto List Members in the VB Editor
A few tips to make your code-writing easier. - Determining the Number of Printed Pages
How to determine how many pages will be printed. - Using VBA to Update Your Excel Code Modules
How to write VBA code that modifies code. - Working With Names in VBA
Some VBA techniques that are useful when dealing with names. - Deleting All Empty Rows
A fast and efficient subroutine to delete all empty rows in a worksheet. - Displaying Help
A technique that makes it easy to display help topics. - Opening a Web Document From Excel
A simple VBA technique that launches the user's default Web browser and loads a specified document or URL. - Generating Permutations
A recursive subroutine to generate all permutations of a string. - Selecting the Maximum Value in a Range
VBA code for a handy utility that selects the cell that contains the maximum value. - VBA Debugging Tips:
General tips on debugging VBA code. - Working With Variable-Size Ranges:
A variety of VBA techniques that let you work with ranges that will not always be the same size. - Copying a Multiple Selection
VBA code for a utility that lets you copy and paste a multiple range selection (something that's normally impossible). - Understanding Object Parents:
Three custom worksheet functions demonstrate how to make use of an object's parent object. - Undoing a VBA Subroutine:
An example of a VBA routine that can be undone with the Edit Undo command. - Printing a Workbook's Full Path in a Header or Footer:
A subroutine that inserts the full path and file name into the footer for every sheet in a workbook -- something that's not normally available in Excel. - Referring to Ranges in Your VBA Code:
A discussion of the various ways to refer to a range in a worksheet. - Using Object Variables:
How (and why) to use object variables. - Looping Through a Range Efficiently:
How to create a macro that performs an operation on each cell in a range - and does so quickly and efficiently.