Excel
Find links in the ActivWorkbook (formulas, range names, charts and PivotTables)
brettdj
06/28/2009
Using Regular Expressions (RegExp) in Excel
05/09/2009
Create a temporary UserForm to show the user's Colour Palette
Return IP Address into cell A1
Simulate a Poker Game
05/08/2009
Delete groups of rows using autofilter with VBA (Delete rows 1-9, 11-19, 21-29 etc)
Prevent users from selecting any cell in a specific range
Multiple Goal Seek code
Delete then restore all data tables in a workbook
Highlight all cells in the active sheet that have formula links to other sheets in this workbook
05/06/2009
Extract Email Data From Outlook Global Address List - GAL
Delete Rows Based on Column Criteria
Highlight all formula cells on the activesheet that contain both cell refs and constants
Automate Internet Explorer from Excel (google search)
Log In to an Internet Site
List File Attributes of Directory and Subdirectores
Format cells with positive, negative, or zero numerical values in a consistent format.
Add String Text to Existing Cells
05/02/2009
Code to move to the same cell in either the next or previous worksheets
Multiple Apps
Export Excel range or Excel chart to PowerPoint (linked or unlinked)
03/22/2005
Methods of repeating a string in VBA - FOR loop not required
02/11/2005
Creating a temporary audit toolbar to trace dependents & precedents on a protected sheet
01/24/2005
Please read our Legal Information and Privacy Policy Copyright? 2004 - 2005 VBA Express