Application   Coder    Page 

Excel

Find links in the ActivWorkbook (formulas, range names, charts and PivotTables)

brettdj

06/28/2009

Excel

Using Regular Expressions (RegExp) in Excel

brettdj

05/09/2009

Excel

Create a temporary UserForm to show the user's Colour Palette

brettdj

05/09/2009

Excel

Return IP Address into cell A1

brettdj

05/09/2009

Excel

Simulate a Poker Game

brettdj

05/08/2009

Excel

Delete groups of rows using autofilter with VBA (Delete rows 1-9, 11-19, 21-29 etc)

brettdj

05/08/2009

Excel

Prevent users from selecting any cell in a specific range

brettdj

05/08/2009

Excel

Multiple Goal Seek code

brettdj

05/08/2009

Excel

Delete then restore all data tables in a workbook

brettdj

05/08/2009

Excel

Highlight all cells in the active sheet that have formula links to other sheets in this workbook

brettdj

05/06/2009

Excel

Extract Email Data From Outlook Global Address List - GAL

brettdj

05/06/2009

Excel

Delete Rows Based on Column Criteria

brettdj

05/06/2009

Excel

Highlight all formula cells on the activesheet that contain both cell refs and constants

brettdj

05/06/2009

Excel

Automate Internet Explorer from Excel (google search)

brettdj

05/06/2009

Excel

Log In to an Internet Site

brettdj

05/06/2009

Excel

List File Attributes of Directory and Subdirectores

brettdj

05/06/2009

Excel

Format cells with positive, negative, or zero numerical values in a consistent format.

brettdj

05/06/2009

Excel

Add String Text to Existing Cells

brettdj

05/02/2009

Excel

Code to move to the same cell in either the next or previous worksheets

brettdj

05/02/2009

Multiple Apps

Export Excel range or Excel chart to PowerPoint (linked or unlinked)

brettdj

03/22/2005

Excel

Methods of repeating a string in VBA - FOR loop not required

brettdj

02/11/2005

Excel

Creating a temporary audit toolbar to trace dependents & precedents on a protected sheet

brettdj

01/24/2005

 Application   Coder    Page 

Please read our Legal Information and Privacy Policy
Copyright? 2004 - 2005 VBA Express