Now based in the London, living in Earls Court. Not the most orginal location for an Australian expat but the kids love the nearby parks.
Linkedin Profile @
http://www.linkedin.com/profile?viewProfile=&key=2996376.
My free "The Duplicate Master" addin for Excel (2000 or higher) has found a new home at Bob Phillip's site,
http://xldynamic.com/source/xld.DupMaster.htmlMy Excel KB articles at VBAeXpress can be found at
http://vbaexpress.com/kb/default.phpExcel - Automate Internet Explorer from Excel (google search)
Excel - Code for a self-destructing Workbook
Excel - Code to move to the same cell in either the next or previous worksheets
Excel - Create a temporary UserForm to show the user's Colour Palette
Excel - Creating a temporary audit toolbar to trace dependents & precedents on a protected sheet
Excel - Delete groups of rows using autofilter with VBA (Delete rows 1-9, 11-19, 21-29 etc)
Excel - Delete Rows Based on Column Criteria
Excel - Delete then restore all data tables in a workbook
Excel - Extract Email Data From Outlook Global Address List - GAL
Excel - Extract summary data from closed files
Excel - Format cells with positive, negative, or zero numerical values in a consistent format.
Excel - Highlight all cells in the active sheet that have formula links to other sheets in this workbook
Excel - Highlight all cells in the active sheet that have formula links to other workbooks
Excel - Highlight all formula cells on the activesheet that contain both cell refs and constants
Excel - List File Attributes of Directory and Subdirectores
Excel - Log In to an Internet Site
Excel - Methods of repeating a string in VBA - FOR loop not required
Excel - Multiple Goal Seek code
Excel - Prevent users from selecting any cell in a specific range
Excel - Return IP Address into cell A1
Excel - Simulate a Poker Game
Excel - Using Regular Expressions (RegExp) in Excel
Multiple Apps - Export Excel range or Excel chart to PowerPoint (linked or unlinked)