September 2010
August 2010
- 31 Dymo LabelWriter Part II
- 30 Abbreviating Company Names
- 27 Bushy Trees
- 19 A Hundred Thousand Name Managers!
- 12 Showing Hidden Sheet and Workbooks Dialog in VBA
- 10 Printing to a DYMO LabelWriter 450 from VBA
- 9 Contextual PivotTable Userform
- 8 Regular chart version of a sparkline
- 6 Lightening colors
- 4 The True Cost of Spreadsheets
- 3 Toggle PivotFields from Count to Sum
July 2010
- 29 Pages to Print
- 28 Good Row Bad Row
- 22 Runway Math
- 21 Test an Object and Its Property
- 20 Personal.xls
- 19 String Building Class
- 13 Properties and Object Continued
- 12 Properties and Objects
- 9 Creating a Parent Class
- 9 Preventing Workbook_Open events from running (2)
- 8 Forever Stamps
- 8 Class Property Fixed Values
- 7 Button image add-in for 2007 and 2010
- 7 Make Plural
- 6 Public Variables in Class Modules
- 4 Custom Collection Class
- 2 WTF
- 1 VBA Rounding
- 1 Saving Outlook Email and Attachments
June 2010
- 29 Incongruity
- 28 List Conditional Formatting in Excel 2003
- 25 Most Frequent Occurence
- 18 Formatting Pivot Tables
- 17 Generate Sample Data
- 16 Alternative Time Picker Problems
- 15 Show Locked Cells
- 14 UK Excel Developer Conference - Monday 12 July 2010 - London
- 8 Hide Multiple Worksheets
- 1 VBA Forums
May 2010
- 28 Calendar Control DLL on Windows 7 64 Bit
- 27 Comparing Two Lists
- 23 Excel control idMso’s of Excel 2010
- 13 Omaha CPA Who Knows Excel
- 12 Performance of linked pictures
- 10 Find and Replace Hyperlinks
- 5 GoodTodo
- 4 Creating Dynamic Named Ranges in VBA II
- 3 Logic Problem Grid
April 2010
- 29 Consulting Tools
- 28 Dynamic Columns in MS Query II
- 28 Dynamic Columns in MS Query
- 27 Prioritize List on a Worksheet
- 25 Windows Live Mail (WLM) and Excel problem part two
- 24 TM AutoChart: Connect chart axis parameters to cell values
- 20 Illegal File Names
- 16 Creating Dynamic Names in VBA
- 16 Listing Format Conditions
- 15 Display a message for a specific duration
- 14 On a Personal Note
- 14 Windows Live Mail (WLM) and Excel problem
- 7 Modern Excel Charts
- 5 ByRef Arguments and the Application.Run Method
- 1 Syncing Data Validation
March 2010
- 25 Copying Worksheets with VBA
- 24 Six
- 23 Maxif and Minif with Multiple Variables
- 18 PowerPivot - Part 4 of 4: A geographic visual display of 18 million US Census records
- 16 Charting House
- 15 Language Detection
- 11 Importing text files in an Excel sheet
- 10 Using the MATCH Function for a Linear Search and a Binary Search
- 9 Keno Odds
- 8 Getting Array Data from a Filtered List in VBA
- 5 Plain and Pretty
- 4 Office Automation
- 2 PowerPivot - Part 3 of 4: Conditional Shape Colors
- 2 Web Query Lessons
- 1 IsHex Function
February 2010
- 27 PowerPivot - Part 2 of 4: Prepping the census data
- 26 PowerPivot - Part 1 of 4
- 26 Listing Formulas
- 25 Drawing in Excel
- 23 Sheet Tab Colors
- 21 New RDBMail Mail add-in for Excel/Outlook 2007-2010
- 19 Consolidating Timesheets
- 18 Web Apps
- 16 OLAP Catastrophic Failure
- 10 Formula Tips
- 9 VBA Assessment
- 8 List Custom Lists
- 5 Google Chrome
- 4 ISO Year
January 2010
- 29 Perfect Training
- 28 MZ Tools Non-Modal Dialogs
- 28 Declaring API functions in 64 bit Office
- 26 VBA Page of Pages in a Cell
- 25 Cash Advances on Credit Cards
- 22 Margins Don’t Fit Page Size
- 21 Culling You RSS Feeds
- 15 Friday Link Dump
- 14 Problems related to KB973475 and KB973593
- 14 Capitalizing Web Addresses
- 13 Opening Files on Startup
- 12 2009 in Review
- 7 New Year’s Resolution: No More Offset
December 2009
- 30 Software Pricing
- 29 Using controls on worksheets
- 23 Hello World Button on a Ribbon
- 23 Date Formatting
- 22 Methods in Excel Podcast #3
- 20 New content on my site about 2010
- 16 Pasting Excel Ranges in Outlook
- 10 Multiple Substitute VBA
- 9 Multiple Substitute Formula
- 7 Preventing auto_open and Workbook_Open events from running
- 5 Formula Tokenizer
- 3 Short DOS Path
- 2 Benford’s Law
- 2 ExcelUser Sale
- 1 How to Get Office for Free
November 2009
- 30 Getting Started in VBA
- 24 Methods in Excel Podcast
- 21 Changing names of some files in a directory
- 20 Office Web Apps
- 18 Learn VBA to be Lean
- 17 Visualizing data in Excel: How would you interpret this graphic?
- 17 CodeColorer
- 15 Visualizing data in Excel: Balancing the physical and logical dimensions of a chart
- 12 Removing Spaces from File Names
- 11 Programming Music
- 10 JoinRange
- 7 Euler Problem 188
- 5 Four Letter Words
- 5 Target a screen resolution
- 4 Three Letter Words
- 3 Everything Must Go
- 1 Starting multiple programs in MS Windows
October 2009
- 29 Dynamic Ranges in Charts
- 28 Borders on Single Columns or Single Rows
- 26 A quick tip - Working with arrays with unknown bounds
- 22 The Whole Column
- 16 Arranging Multiple Windows
- 12 Numbers in Disguise
- 12 Converting Cells Formatted as Text
- 8 The Currency Format
- 5 QueryCell
- 3 Summing the Digits of a Number
- 2 MVP-ness Envy
September 2009
- 30 Adding Every Other Cell
- 29 Multi-Column PivotTables
- 28 Software Trial Periods
- 26 Euler Problem 203
- 23 International Excel Issues
- 22 Site Speed
- 17 One Keyboard Shortcut
- 16 Custom Sorting
- 15 Quick Counting in Excel
- 11 Bar Is the New Pie
- 9 Golf Scores
- 9 Office 2010 Icons
- 8 Where is my button that I add to the QAT of my workbook
- 7 Searching multiple web resources
- 5 Euler Problem 119
- 4 Alt + Number
- 3 Hide a Column
August 2009
- 29 Euler Problem 109
- 25 Cumulative Percent
- 24 NFL Slotting
- 19 Using VBScript to monitor Office events…or not
- 18 Formatting Taskpane
- 17 Golf Charts — Another Take
- 14 Golf Charts
- 13 Russian Peasant Spreadsheet
- 12 Russian Peasant Multiplication
- 11 Make Office Better
- 10 Quick Find Regular Expressions
- 8 Euler Problem 205
- 7 Quick Move
- 6 Moving Sheets
- 5 The Big Bang Servo Diet
- 4 Daily Dose of Chinese
- 1 Euler Problem 76
July 2009
- 31 Navigating Protected Sheets
- 29 Outlook Mail Worksheet Template for Excel 2007-2010
- 29 Conditionally Load Excel Add-ins
- 28 Euler Problem 124
- 24 Friday Notes
- 21 Excel Word Search Generator
- 20 VBA Random Integers
- 11 Euler Problem 112
- 10 Office 2010 Trailer
- 10 Delete vcf Attachment from Incoming Emails
- 9 Using Windows 7 Libraries with Older Excel Versions
- 6 First to 40,000
- 5 The Mystery of the Disappearing Range Name
- 1 June Stats
- 1 Interrupting Calculations
June 2009
- 29 Quick PivotTables
- 27 Animate a greeting with Excel and VBA
- 26 XL
- 23 Euler Problem 83
- 20 Euler Problem 81
- 19 Look Up
- 18 Tip: Updates for Microsoft Office Excel 2007 Help
- 18 Entering Dates Into Cells Part II
- 16 Reading XML Files in VBA
- 15 Euler Problem 123
- 13 Hide or display Custom Ribbon Tabs, Groups or Controls with VBA code
- 12 Creating State Maps with XY Charts
- 11 Bacon Bits Blog
- 10 Work Breakdown Structure Numbering in Excel
- 9 Professional Excel Development Book Winner
- 6 Euler Problem 120
- 4 Applying the Comma Style
- 2 Professional Excel Development Second Edition
May 2009
- 29 Euler Problem 206
- 29 Hungarian Notation Again
- 27 New Excel Blog
- 26 Advanced Excel Conference
- 22 Include All in Array Formulas
- 21 Dallas Wrap Up
- 18 Adding RibbonX code to an Office OpenXML file using VBA
- 11 Ravine Enivar
- 11 Excel Dashboard and Visualization Boot Camp
- 10 Zip Activeworkbook, Folder, File or Files with 7-Zip (VBA)
- 9 Euler Problem 100
- 8 Hidden Columns in HTML
- 6 Excel and Access Integration Workshop
- 6 Editing elements in an Excel OpenXML file using VBA
- 6 Using LINQ to find and open in Excel 2007 the newest file in a folder
- 4 Finding External Links in Data Validation
- 1 Opening the Newest File in a Folder with VBA
April 2009
- 28 Calculating Wind Direction
- 27 Data Sets
- 25 Euler Problem 80
- 24 Related Sheets Stack
- 22 Previous Sheets Stack
- 21 VLOOKUP on Two Columns
- 20 The Wire: 100% Finished
- 20 VLOOKUP
- 19 Office 2007 SP2
- 17 Inventory Freight Calculation
- 16 Office “14” – Microsoft Office 2010
- 16 Historical U.S. Tax Rates
- 15 OfficePalooza
- 14 Opening Outlook Attachments
- 13 The Famous Nick Hodge
- 7 Illegal Range Names
- 6 Worst Excel Practices
- 5 Late Bound Enumerations
March 2009
- 30 Elle’s Birthday
- 27 A Little Companionship
- 27 Bumping Email
- 25 Galleries in the Ribbon
- 25 Out of Rows
- 22 Euler Problem 104
- 20 Outlook Default Folders
- 19 Excel multi-threading calculations on 8 processors
- 17 Graphics I Grok
- 15 Euler Problem 62
- 13 Bingo
- 12 Looping Through Sheets
- 11 Code Construction
- 10 VBA Here to Stay
- 8 Update VBA code page for Tables and Create/Mail PDF files
- 8 Euler Problem 66
- 6 Text to Columns Regular Expressions
- 5 Quick TTC Output
- 3 Quick TTC Classes
- 2 Sizing Listbox Columns
- 1 Quick Text to Columns Utility
February 2009
- 27 Collections Can Be So Insensitive
- 26 Get the Path to My Documents in VBA
- 24 Euler Problem 75
- 24 Euler Problem 73
- 24 Economic Stimulation
- 23 Code Snipit to Test
- 22 Euler Problem 36
- 20 Green Eggs and Ham
- 18 Inflexible Find
- 17 Translating Excel Applications
- 17 My own Euler problem
- 16 External Links
- 15 Euler Problem 79
- 13 Excel Movie Reviews
- 13 Site News
- 12 Ego Charts
- 11 Excel Memory Usage
- 10 Paying the Check
- 9 Which Range Am I Counting?
- 8 Euler Problem 45
- 6 C# Macro Recorder
- 5 How to Twitter from Excel
- 5 Styles in Excel
- 4 ADO Slower on Linked Tables
- 3 Excel Using a Lot of CPU
- 1 Euler Problem 23
January 2009
- 31 Looping Through Months
- 29 New Project Workbook
- 27 Useful addition to Outlook 2007
- 27 Finding Stray Text
- 25 A Fresh Start
- 24 Euler Problem 54
- 21 List of Office Developers
- 19 Wordpress Upgrade
- 18 Euler Problem 43
- 17 Project Euler questions and Excel solutions
- 16 Excel Consulting Buyer’s Guide
- 15 Office14 Sneak Peek
- 15 How to Learn Excel
- 14 Dynamic Favorites
- 12 Large Number Arithmetic
- 10 Euler Problem 89
- 9 Free Office
- 8 Euler Problem 52
- 8 VBA WTF
- 7 Check Your Stock from Excel
- 6 Arrays Explained
- 4 Euler Problem 102
- 2 Recursion as a performance boost!
- 2 Euler Problem 22
- 2 Bubble Sorts
- 1 Excel Sample Data
December 2008
- 31 I Resolve
- 30 Euler Problem 19
- 30 Euler Problem 55
- 28 Euler Problem 31
- 23 UDFs and Moving Add-in Files
- 22 Euler Problem 16
- 21 New Contributor
- 21 VBA Framework II
- 19 Bowl Picking
- 11 Create Unique List from Selected Cells
- 7 VBA Framework
- 6 UK Excel User Conference
November 2008
- 26 AutoFiltering on Months
- 20 Add-ins in Excel 2007
- 20 XML and Excel
- 15 Creating Classes from Access Tables
- 14 Lessons in SQL
- 14 Table Tools in Excel 2007
- 6 Ribbon, You’re Nothing to Me Now
- 5 www.jkp-ads.com Anniversary and Website Update
October 2008
- 27 My First Ribbon
- 26 Disable Excel 2003 Menu Accelerators keys in Excel 2007
- 24 Free Financial Advice
- 22 Automated Formulas Testing
- 17 Handling Delimeters in CSV Files
- 16 Excel in the News
- 10 Identifying Sheets
- 8 Range within a Range
- 1 Star Rating Number Format
- 1 Three Porting Issues
September 2008
- 24 Update
- 16 When Is Friday
- 10 Testing VBA Code
- 10 Three Things
- 7 The Ultimate List of Excel RSS Feeds
- 5 The Life of a Lion Tamer
- 2 Task Recorder Version1
August 2008
- 29 Twittering Away the Day
- 28 User Initials in Excel
- 27 Random Numbers Repeating
- 25 Twitter
- 23 The Ultimate Steal
- 23 Add missing built-in commands to the QAT or Ribbon
- 21 Retirement Calculator
- 17 Counting Olympic Medals
- 15 My Coding Technique
- 14 My Places on File Dialogs
- 13 ShortcutText on Menu Items
- 7 Change built-in groups in the Ribbon
- 4 Data Visualization? Sir, Yes Sir!
- 3 Increment File Names
July 2008
- 30 The NEW Spreadsheet Page
- 29 Multiple Add-ins
- 29 Filter by Selected Cell’s Value, Cell’s Color or Cell’s Font Color
- 28 Free Excel Stuff
- 22 List Userform Hotkeys
- 17 FillSeries Keyboard Shortcut
- 16 Determine Which COM Add-ins Are Installed
- 14 Andrew’s Excel Tips
- 11 Peltier Loves Pie
- 9 Lookup Second Occurrence
- 5 Office Community Clips
- 2 Excel Links
- 1 To Disable or Not To Disable, That Is the Question
June 2008
- 26 Identify Empty Cells in VBA
- 24 Create a QueryTable from an Excel Source in VBA
- 20 Using an Analysis Template — Updating the data source
- 18 Excel Blog Happenings
- 18 On-the-fly data entry form
- 17 Alive and Well
- 6 Settling Debts
- 4 Variable Hyperlinks
- 2 Fixing Links To UDF’s in Addins
May 2008
- 23 Giving IE the Focus
- 21 PivotTable Markup Language
- 15 Recording Macros
- 14 Showing An Array On A Form; Autosizing ColumnWidths Of A ListBox
- 13 Is VBA Recovering?
- 12 Excel 2007 Tip o’ the Day
- 10 Simple Gantt Chart
- 8 Using a Class Property to do more than just Assign or Query a Value
- 6 Double Clicking Through a List
April 2008
- 29 Efficient Looping
- 28 Testing Strings Using Left
- 23 Printing First Page of Email in Outlook
- 21 VBE Bookmark add-in for Office 2000-2007
- 14 I’ve Arrived
- 13 Mike Won!
- 7 Tab Groups
- 5 Copy Paste to External Application
- 5 Getting the Printer Port
- 3 Investing in Lean
- 1 Updating Stock Quotes
March 2008
- 31 Can You Believe
- 31 Excel and Music
- 28 Limits
- 28 Two popular tools updated.
- 25 External Data Worksheets
- 23 Random Sorts
- 18 Excel User Conference Download
- 16 Conduct in Reserve
- 9 G’day
- 4 Australian Tips
February 2008
- 28 Fixed Width Text Files
- 27 Using the Object Browser
- 18 Presidents Day Chart Sale
- 14 New Excel for Old Guys
- 10 Steady vs. Volatile
- 9 MSDN Primers
- 9 G’Day Excel
- 4 Bogus Compile Errors
January 2008
- 31 Dealing with Ribbons and Menus - Avoiding Two Versions
- 31 Some Links
- 30 An Interesting Story
- 30 Excel security flaws out in the open
- 28 CommandButtons via Visual Basic 6.0
- 24 Rows and Columns
- 17 Multiple Parameters in External Data Queries
- 16 Blog Stats
- 11 Hash and Stack in VBA
- 10 Office SP3 and File formats
- 10 Can’t Access Table in MS Query
- 9 Macros are disabled when you open password protected workbooks
- 8 Excel User Group Site
- 8 Excel and the Google Chart API
- 4 Subtotals Ignoring Subtotals
December 2007
- 28 Terminating Dependent Classes
- 23 Page update: Copy a range from closed workbooks (ADO)
- 21 Fixing Help
- 18 Google Toolbar Slows Excel
- 17 Catching Paste Operations
- 14 Donut Selection
- 13 VBA Code Documenting Tools: Project Analyzer and Visustin
- 9 Office 2007 SP1
- 7 Google Chart API
- 4 Borders All Around
- 3 ExcelRefTool; A New Formula Auditing Tool
November 2007
- 29 Retiring at 40g
- 29 Copy a customized QAT from one workbook to another (Add-in)
- 27 Collaboration Suggestion
- 25 Select Adjacent
- 20 Customize the images of the buttons in the QAT
- 19 Two Links from the Cloud
- 18 DIY Context Menu
- 17 Chart Pattern Fills in Excel 2007
- 16 Big Butter
- 15 Give one get one…laptop that is
- 12 Beware the Indian Army
- 10 The Decline of VBA
- 9 VBA Help Stats
- 9 VBA for Beginners
- 1 “Animate” a 2007 RibbonX image
- 1 Gallimaufry
October 2007
- 31 UK Excel User Conference
- 30 Updated Box and Whisker Chart Utility
- 24 My Downloads and why I like New Book Navigator
- 19 Splitting the Check
- 17 Count Everything But…
- 11 Comments on Comments
- 11 Windows Media Player Delay
- 11 Beta testing request
- 10 Calculation Bug Fixed
- 5 Twenty-two Hours
- 2 Merge data from different workbooks with the RDBMerge add-in
September 2007
- 30 MRU(”Most Recently Used”) file list in Excel 2007
- 25 2007 Calculation Bug
- 24 Office Football Pool
- 18 Performance Monitor
- 17 Preventing Event Conflicts
- 17 Excel Easter Eggs
- 7 Formula Challenge
August 2007
- 30 Positioning a Userform Over a Cell
- 30 Ian’s Favorite Excel Sites
- 30 Table Drive Ribbon
- 22 Collection Add and Functions
- 21 Most Impressive Excel App?
- 21 Excel 2003 Lessons
- 21 Returning a Limited Collection from a Class
- 17 Double Click to Exclude Numbers
- 17 Two new range functions: Union and Subtract
- 10 Quick Notes
- 9 Dilbert on Spreadsheets
- 8 Readability with Custom Classes
- 7 MZ Tools 6.0
- 6 IsMissing
- 3 VB(A) and InternetExplorer and XMLHttp
- 3 Time Picker
- 2 Excel Team Blog
- 1 Excel as a Really Bad Database
July 2007
- 31 The File Cannot Be Accessed
- 27 Data Entry Form Enhancements
- 17 Magnifying Linked Ranges
- 15 Trig
- 10 Unique Fruit
- 10 Navipane Update
- 7 Menu in the ribbon with different languages
- 5 The Opportunity Cost of Fireworks
- 2 Week of the Month
- 1 Having a number and a formula “co-exist” in a cell
June 2007
- 26 Will You Still Need Me
- 24 Sending mail from Excel with CDO
- 21 Solver Code Doesn’t Like Shapes
- 21 Missing VBE Toolbars
- 21 CEILING Part 3
- 14 Parsing the Bible
- 14 Reverse compatibility problem of the old ATP functions
- 14 EuSpRIG 2007
- 8 Rewriting CEILING for Arrays
- 8 Challenge: Changing font of a forms checkbox
- 6 Subtracting Binary Fractions
- 6 Rewriting the CEILING Function
- 4 Help Context IDs for Excel 2000-2007
- 1 Copying VBAproject components
May 2007
- 31 More Dueling Banjos
- 25 License Acceptance Form
- 24 Office Specialist
- 22 EnableCancelKey
- 21 The New Excel 2007 File Format
- 17 TakeFocusOnClick and Default
- 16 Updating Mulitple ListView Rows
- 14 Listing an Object’s Properties and Methods
- 8 Combobox Events in an Add-in
- 4 Error Handling Template
- 2 Temperature Number Formats
- 1 Working with Tables in Excel 2007 (VBA)
April 2007
- 30 Maintaining Code
- 26 Merge Add-in
- 25 Min and Max across sheets
- 25 More Ribbon Replacement
- 25 Converting Mapped Drives
- 24 New Theme
- 18 Forward, Into the Past
- 17 Cannot Find the Input Table
- 16 New Worksheet Location II
- 14 VBA Editors
- 13 DDoE Upgrades
- 13 Two Excel 2007 Webcasts
- 12 Excel VBE Multiline Search And Replace
- 12 Excel VBE Multiline Search And Replace
- 11 Who’s the Fool Now?
- 10 Navipane
- 9 Still More Free Stuff (Almost)
- 2 Free Stuff
- 1 Teaching an old dog new tricks: A 2007 skin for older add-ins
March 2007
- 30 Excel Podcasts
- 29 The Great Chart Debate
- 27 A Handsome Lot
- 27 Inaugural UK Office User Group Event
- 26 Sent Items Cleanup
- 25 The Organic Diet
- 23 XY Chart Labeler Version 7.0
- 23 More Outlook Tags
- 23 Noteworthy Ranges
- 21 New Worksheet Location
- 21 Installing An Excel Add-in Using Setup Factory
- 19 Outlook Tags
- 17 Things I’ve learned about MVPs
- 12 Summit Time and the Living Is Easy
- 9 Converting Names to Local
- 8 Excel MVP Web Sites
- 7 Code Satisfaction
- 6 Useful Utilities
- 4 Fractions of Seconds
- 1 Slowness
February 2007
- 28 Two new articles on MSDN
- 27 Formulas Winner
- 25 Nz Function
- 25 Build-in Excel 2007 controls
- 24 Too Few Parameters Expected N
- 21 Find Position of First Capital Letter in a String
- 19 Updating An add-in Through the Internet
- 18 ATP 2007 Bug
- 17 Event Sequence
- 16 Excel 2007 Formulas
- 16 RibbonX Sample Chapter from Excel 2007 VBA Programmer’s Reference
- 15 Excel 2007 Likeability
- 14 Coming Soon: Office 14
- 13 Ribbon XML
- 12 The Future of Excel Charting
- 10 The New MacroMan
- 10 Yet Another Progress Bar
- 7 OLAP Primer
- 6 Windows Mail bug in Vista
- 6 Musical Excel
- 1 Excel VBA Code Cleaner Version 5.0
- 1 New version of Autosafe (and free too!)
January 2007
- 26 Buying Add-ins
- 25 Selection Offset
- 23 Dynamic Sorting With a UDF
- 21 Stranger Than Fiction
- 21 Subtotals to summarize data
- 20 Excel 2007 Menu
- 19 Beta Testers For PUP v7?
- 18 Obscure Excel VBA error: “Invalid Picture”
- 14 Creating Wildcards
- 12 Modifying Shapes (and Charts) With UDFs
- 12 Working with Data Tables in Excel 2007
- 11 Listbox Drag and Drop
- 9 Unprotect all Worksheets in all Workbooks
- 7 Website update
- 6 Deleting Hyperlinks
- 5 Inconsistent Formulas
- 5 Macro Shortcut Keys
- 1 Best wishes for 2007
December 2006
- 29 Weekend Mishmash
- 28 Caller and Custom Commandbars
- 27 Power Formulas for Unique Data
- 26 Formulas for Unique Data
- 26 ListView
- 20 Pseudo Scroll 2
- 18 Pseudo Scroll
- 15 Too Many Colons
- 14 Naming Userform Controls
- 10 New Desk
- 8 Weekend Music Post
- 5 What Level Are You?
- 5 Docking VBE Windows
- 4 Writing To A Range Using VBA
November 2006
- 29 HTML Tables
- 28 Calculating Total Payment After Fees
- 24 Name Manager 4 for Excel 2007 RTM
- 23 Quickbooks SDK Part IV
- 19 Storing Formulas II
- 18 Desktop Calendar
- 16 Displaying CommandBar FaceID Images
- 12 New Charting Utility - Waterfall Charts
- 11 Weekend Forum
- 10 Posting From Word 2007
- 10 Quickbooks SDK Part III
- 10 RibbonX Forum
- 7 Storing Formulas
- 5 Excel 2007 Upgrade Poll
- 4 Weekend Forum
- 1 Quickbooks SDK Part II
October 2006
- 31 Quickbooks SDK Part I
- 31 Flashback
- 31 Excel 2007 FAQ (Draft)
- 29 Two website additions: Properties in a standard module and a chapter on Names and Formula formatting
- 29 SaveAs in Excel 2007
- 29 PDF in Excel 2007
- 27 Weekend Forum
- 27 Exporting All Graphics
- 25 Progress Charts
- 24 Instant Slide Show
- 20 Weekend Forum
- 18 Characters Count
- 17 Cleaning Pasted Code
- 16 Monday Forum
- 16 Excel/Outlook mail add-in version for Excel 2007 Beta2 TR
- 11 Dynamic Text Sorting
- 10 COUNTIF Bug
- 9 Async XmlHttp calls
- 6 Weekendly Dose
- 5 A new utility — Audio Alerts
- 5 .Net and Excel Blog
- 4 Control Arrow
- 3 Force Upper Case
September 2006
- 29 Weekend Forum
- 29 Excel to GIF
- 25 West Coast Excel User Conference
- 25 Keyless Entry
- 22 Want To Be Acknowledged?
- 22 Hiding the Cursor
- 22 Weekend Forum Weert (The Netherlands) style!
- 19 Position of icons in customized Toolbars
- 15 Weekend Forum California Style
- 15 Transposing the Formulas in a Table of Cells
- 15 Customize Ribbon UI for Excel 2007 with ‘Managed’ COM Add-ins (VB.NET 2005)
- 14 Beta 2 Technical Refresh
- 13 Scaled In Cell Charting
- 10 New Charting Utility - Dot Plots
- 10 Customize RibbonX UI for Excel 2007 with COM Add-ins (classic VB)
- 9 New Charting Utility - Box and Whisker Charts
- 8 Weekend Forum
- 7 New Charting Utility - Quick XY Charts
- 6 Displaying Thousands
- 5 Happy Birthday Excel
- 2 It’s not all about rectangles
- 1 Weekend Forum
August 2006
- 30 UserForm Controls
- 28 Sharing RibbonX controls across application-level (XLAM) add-ins
- 25 Weekend Forum
- 24 Some more observations on application level add-ins and RibbonX with Excel 2007
- 24 Creating and deploying Managed COM add-ins with VB.NET 2005 - Part X
- 24 Least Common Pathinator
- 22 Feeling good about an Office Marketplace event
- 22 Creating and deploying Managed COM add-ins with VB.NET 2005 - Part IX
- 21 Shortcut to Styles
- 21 Code in Comments
- 21 Capture Deleted Rows
- 21 Creating and deploying Managed COM add-ins with VB.NET 2005 - Part VIII
- 18 Weekend Forum
- 18 Using custom icons with an application-specific add-in in Excel 2007 Beta 2
- 17 Creating and deploying Managed COM add-ins with VB.NET 2005 - Part VII
- 16 Hello! and a report of an initial UI-specific experience porting an Excel add-in to 2007
- 16 Creating and deploying Managed COM add-ins with VB.NET 2005 - Part VI
- 15 Too Random
- 15 Creating and deploying Managed COM add-ins with VB.NET 2005 - Part V
- 14 Creating and deploying Managed COM add-ins with VB.NET 2005 - Part IV
- 13 Mail with CDO for Win 2000
- 11 Weekend Forum
- 11 Creating and deploying Managed COM add-ins with VB.NET 2005 - Part III
- 9 Reading Binary
- 8 New Workbook Task Pane
- 8 The Beginning of the End
- 7 Creating and deploying Managed COM add-ins with VB.NET 2005 - Part II
- 4 No Topic
- 4 Excel 2007 Bible: Done!
- 3 Creating and deploying Managed COM add-ins with VB.NET 2005 - Part I
- 1 Cell Border Shortcuts
July 2006
- 30 Beta for Sale, Get Your Hot, Fresh Beta
- 30 Custom Ribbon Builder
- 28 Calculating Running Totals without Errors
- 27 Icon Matchgame
- 26 Song Inspired Movies
- 25 Spreadsheets Are the Devil
- 23 Office as A Development platform
- 22 If it ain’t broke…fix it Part 1 of many
- 22 Under the Laser
- 21 Excel 2007 Color Scale
- 20 Very Hidden Worksheets
- 17 Worthless Menus
- 14 For the Last Time, No!
- 13 Random Name Generator
- 12 Probabilistic Lookup
- 11 Confessions of an Excel Junkie
- 10 User Interface Guidelines
- 7 Monitor Directory
- 7 Making A Cell Entry
- 5 Where are the Excel 2003 commands in Excel 2007
- 5 Userform Gallery
June 2006
- 30 Irregular Color Banding
- 29 Domain Worksheet Protection
- 28 Office 2007 Test Drive
- 28 There’s One Born Every Minute
- 28 Everything We Could Find on Microsoft VBA
- 24 Measure & Evaluate The Quality of The Data
- 21 UNC Path
- 16 The F Word Count
- 14 Basic Excel Screen Vocabulary
- 13 Move a userform by dragging within the form
- 12 Name Manager 4 released
- 12 Analyzing Vendor Discounts
- 12 Web based services
- 7 Google Spreadsheets
- 2 Customizing The Excel 2007 UI
- 2 Tools to use with Excel
May 2006
- 24 Creating Folders with MkDir
- 23 2007 Microsoft Office system Beta
- 23 Name Manager 4: Last call before release
- 22 Commercial use of SQL Server 2005 Express Edition?
- 17 SQL Query Builder
- 16 Excel & PDFCreator Take II
- 14 Add and remove shortcuts in the Open & Save As dialogs
- 12 Mpemba Speech Code
- 12 Excel & PDFCreator
- 10 The Talking Worksheet
- 9 Add-ins - Excel Loader - A standalone utility to start Excel and load selected add-ins
- 5 Bug in Application.InputBox function
- 4 Excel Junkie Top 10 List
- 1 Excel conference in London (July 19/20th)
April 2006
- 28 Name Manager 4 Beta updates
- 26 Dynamic Table Errors
- 21 Two Variable Lookups
- 20 VBA Userform tip
- 17 Add-ins - Working with Windows registry
- 13 Registering a UDF Take 2
- 12 Add-ins - Where does Windows store the information?
- 11 Testing for Empty Cells II
- 11 Announcing: Name Manager 4.0 Beta
- 10 Error Writing Long Strings
- 8 Increasing Undo
- 7 Name Manager UI: Best of both worlds?
- 6 NewsGator
- 6 Inheriting Formulas
- 5 Excel Upgrade Statistics
- 4 Name Manager UI Poll (2)
- 3 Name Manager UI Poll
- 1 Fixing broken links
March 2006
- 31 Viewing a Limited Range on a Userform
- 31 Index Looping Through a Range
- 29 Read the Manual
- 29 Floating Point Data Types
- 27 Batch GeoCode
- 26 Counting 3D Blocks
- 23 SpecialCells limit problem
- 22 VLOOKUP and INDIRECT
- 21 Self Deleting Commandbar Buttons
- 20 Formula Shortcut
- 18 Disabled Items
- 17 Another Drinking Holiday
- 17 ThisWorkbook and the VBE Immediate Window
- 16 Log Worksheet Changes
- 15 Hoop Dreams
- 13 Counting Code Lines
- 11 Invisible Basic
- 9 Generic undo routine for vba (part 2)
- 6 A menu on a userform
- 5 Dynamic Tables
- 5 Daily Dose Daily Visitors
- 5 Spreadsheet Errors
February 2006
- 27 Months of the World
- 25 3D User Defined Functions
- 24 Date Separator and Regional Settings
- 24 Some Dynamics on www.jkp-ads.com
- 23 Some Online Spreadsheets
- 23 Function Name Contest Winners
- 23 Sorting Arrays of User Defined Types
- 21 Bible Workbook
- 19 3D Array Formulas
- 18 Function Name Contest
- 18 Number Stored as Text
- 17 Registering a User Defined Function with Excel
- 16 Printing Fit to Page Width
- 16 Conditional Compilation Arguments
- 12 Hyperlinks and Network Shares
- 11 New navigation on www.jkp-ads.com
- 10 Streamlining Data Entry
- 10 Conditionally Formatting Command Buttons
- 10 Recording Swimming Splits
- 9 Watching the content of another cell
- 7 iG_Syntax_Hiliter for VBA
- 7 New Skin
- 6 Active Directory
- 5 In Cell Charting
- 5 February Birthdays
- 5 Superbowl Excel
- 3 We May Now Discuss Excel 12
- 1 The deterioration of the MVP-program
January 2006
- 31 3D Running Formulas
- 30 Conditional Formatting Across Sheets
- 29 FTP Via VBA
- 29 3D Formulas
- 28 MOREFUNC AddIn
- 27 Hyperlinks That Run VBA
- 26 The ID Property
- 25 Command Line Arguments in VBA
- 24 Cookbooks R Us
- 24 VLOOKUP Between
- 24 Copy data from an Access database into Excel
- 24 Different approaches to retrieve data from underlying workbooks
- 23 Blinking Cells
- 21 Create Mdb Tables in VBA
- 19 Excel Suggestions
- 16 Remove
DuplicatsDuplicates From Two Dimension Arrays - 16 Remove Duplicates From Arrays
- 12 Between Function
- 9 Sudoku Helper
- 8 ExcelKB’s Forum
- 6 Syntax Error in FROM Clause
- 3 Conditional Formatting and Noncontiguous Ranges
- 3 Back to Work
- 3 Using Parameters With Web Queries
- 1 Happy 2006
December 2005
- 21 Going Bowling
- 20 External Data Properties Whats This Help
- 17 Accelerating Losses
- 14 Not Bits
- 14 Alternating Columns
- 11 Good old DOS
- 10 Relevance Lost - The Raise and Fall of Large Workbooks
- 8 Excel Vulnerability For Sale
- 8 Insert Outlook Signature in mail
- 7 Create Names
- 7 Excel and Business
- 2 Create INSERT INTO SQL Statements
- 2 Decimal To Binary
- 1 Conditionally Formatting Today
November 2005
- 29 Query Editor Add-In
- 29 Searching VBA Projects
- 29 Reader Feedback
- 22 New Job Redux
- 17 New Job
- 15 Formatting Job Numbers
- 11 Noncontiguous Selection
- 11 VBA Bug: Macro in Excel Stops After A Workbook.Open Command
- 9 Change Named Constants in VBA
- 7 Combined Total Download
- 7 Spreadsheets In Education
- 4 Power Formula Technique
- 3 Multi-Threaded Calc In Excel 12
- 2 Good news about databases
October 2005
- 31 Post Move Stuff
- 28 Gypsy Blog
- 28 Show All with a Range Parameter Query
- 27 Invoice App: The Results
- 27 Which Numbers Sum to Target
- 26 Search DDOE in Firefox
- 25 Clipboard Toolbar
- 24 Pentagon Fractal
- 23 Triangle Fractal
- 19 Excel Jobs
- 19 Excel 12 Formula Autocomplete
- 19 Your Assignment: Create A Simple Invoice App
- 19 Automating pastevalues
- 18 AutoFill Macro
- 15 Mouse shortcuts
- 14 Why I’m Looking Forward To Excel 12
- 13 Reading the internet
- 13 Too Many Cells
- 13 Welcome Me
- 12 Jackson Hole
- 12 Office 2003 Add-in: Desktop Language Settings
- 7 The Future of VBA
- 6 Seattle Memories
- 1 World Exclusive Excel 12 Announcement
September 2005
- 27 Excel Wiki
- 26 Living on London Time
- 26 The need of documentation - Part II
- 23 Blog Stats
- 23 Zip with the default Windows XP zip program
- 23 Official Excel 12 Blog
- 22 Themes and Individuality
- 21 New Domain
- 20 Multiple Office installs
- 19 Move After Selection
- 19 The need of documentation - Part I
- 16 List Subdirectories II
- 15 Office 12 UI Video
- 14 Control When Events Are Handled
- 13 Excel 12 Screenshot
- 12 Excel On The Cheap
- 12 Data Validation Images
- 12 Free Encryptor
- 12 Cutting Stock Lengths
- 3 Conditional Formats Manager
- 3 Quick Launch Toolbar
- 2 List Subdirectories
August 2005
- 30 Changing the current directory
- 29 Generic Undo routine for VBA
- 27 Worksheet Legend
- 27 F Lock Key
- 24 Logo Winners
- 24 Excel Encryption
- 23 Toggle Button Events Class
- 23 Counting Unique Entries - Part 1
- 18 Retrieving Display Settings
- 18 Golf Handicap
- 16 Action Photos of My Deck
- 16 Codename to Friendly Name
- 15 Wind Direction Chart
- 14 Email Boilerplate Text
- 13 Pattern Matching
- 12 Cheap Links
- 12 Little Windows
- 8 Calculated Fields in Pivot Tables
- 5 Database Function Criteria
- 3 Excel 12 Is Coming
July 2005
- 30 Wrench vs Screwdriver
- 29 Get Executable path
- 28 Bowling for Dollars
- 28 Office XML Interview
- 28 Office Web Components (OWC) - Part V Spreadsheet control as datasource to Chart Control
- 27 Justify
- 26 Heat Index
- 25 Spreadsheet Errors
- 25 Office Web Components (OWC) - Part IV Introduction Chart control
- 22 Alive and Well
- 19 Wrapping Formulas In An Error Test
- 19 Office Web Components (OWC) - Part III Spreadsheet control
- 17 Logo Finalists
- 17 Scrolling a form
- 16 Multicolumn Sum with Wildcard
- 15 Lab Tests
- 12 WebBrowser Slide Show
- 12 Create Post Slugs
- 11 Office Web Components (OWC) - Part II - Programming the Pivottable
- 8 QueryTable Helper Functions
- 7 Office Web Components (OWC) - Part II - Introduction Pivottable
- 7 Rounding DATEDIF
- 6 New article: Defined Names In Excel
- 5 Office Web Components (OWC) - Part I
June 2005
- 30 Is this number prime?
- 30 Divisonal Double Elimination Brackets
- 30 Conditional Formatting Validation Macro
- 29 Inserting Events Template
- 28 Create Pivottable-reports with VB.NET
- 28 Playing WAV Files
- 27 A Touch of Grey
- 24 The Planning Deskbook
- 23 Excel User Conference
- 23 Download PivotTable Parameters
- 23 Finding cells matching a specific property using the CallByName function
- 21 Finding Modules and Procedures
- 17 Handling Worksheet control events using a class module
- 17 Exposing VBA code through Excel objects
- 16 Starting Handicaps
- 14 Outlook for the Blind Redux
- 14 Stopwatch
- 13 Prioritize List on a Worksheet
- 13 xlColumnWidths Bug
- 11 Unique Values Advanced Filter
- 10 Daily Dose Logo Contest
- 10 The Handicap Function
- 8 Property Sniffer
- 7 IsIn Collection or Array
- 7 A Setup Utility to install your add-ins (take two)
- 6 Get Outlook’s Currently Selected Time
- 5 Multi Column Match
- 3 Java script to show “What’s new” on site
- 2 Textfiles - Part 1: Create Mdbs on the fly
- 2 G’Day Excel Thoughts
May 2005
- 31 Hungarian Notation
- 31 ShellDelete
- 31 Directory Exists
- 30 Phoning It In
- 29 Sneaky Export Data from Applications
- 27 Single List Combobox Filtering
- 27 Replacing text in a cell with more than 1024 characters
- 26 Return the hyperlink
- 25 New Excel Feed
- 24 Where to Start
- 23 Getting Data from a Userform
- 23 A Curious OR
- 22
CaluclateCalculate Last Quarter End - 21 Excel Formula Formatter - Release
- 19 Connecting to MySQL
- 19 Negative Rounding in VBA
- 19 Setting Up the Data
- 19 Encryption Grid
- 17 Encryption Concepts
- 17 Showing a picture from a list of pictures
- 16 Advanced Range Detection
- 15 Sorting Formulas with Sheet Names
- 13 Everything Ain’t a Nail
- 12 Non VBA Table of contents
- 11 Arrays with Offset
- 10 Fix VBA with VBA
- 9 Daily Dose Delivers
- 8 Kindergarten Math
- 5 Inserting Web Pictures
- 5 More Headlines
- 4 Daily Dose Headlines
- 4 Summing Comma Separated Values in a Cell
- 4 Inputbox Validation
- 3 Speech in 2003
- 2 Userform Default Instances
- 2 Spooky Coincidence
- 2 List Desktop Shortcuts
- 1 Chart An Equation
April 2005
- 29 Using Volatile Functions
- 29 Global Defined Names
- 28 Code Documenting Article
- 28 Slashdot Discussion
- 28 What do ByRef and ByVal mean to you?
- 27 Dots in Dims
- 25 Automating MapPoint
- 25 Excel Experts E-Letter
- 25 Incrementing Module Names
- 25 Style Add-ins
- 25 A setup utility to install your add-ins
- 22 My Article is finished!
- 21 Chaining Parameter Queries
- 20 Formula Challenge
- 20 Pivot Table Parameters
- 19 Using Dir With Only Folders
- 19 Funky Comments
- 18 I Have No Ram
- 18 Line Continuation Limit
- 18 Home Again, Home Again
- 18 Creating an addin from an Excel macro: just 2 more chapters to go.
- 14 Geek Vacation
- 13 ErrorProvider
- 11 MSN Spaces Presented by Scoble
- 11 AutoShape Charting
- 8 Dick’s Weight Loss Plan
- 6 JKP Application Development Services Gets Syndicated
- 5 More Local Search To Excel
- 5 REALbasic Offer
- 5 Daily Dose By a Nose
- 4 The Vote
- 4 Creating an addin from an Excel macro.
- 3 A New Daily Dose Look
- 1 Excel Formula Formatter
- 1 Fog Creek Software
March 2005
- 31 Spellchecking One Cell
- 30 Changing the System Cursor
- 29 Setting MultiSelect in Code
- 28 A Rose by Any Other
- 26 Excel Startup trouble
- 25 Oh, My Back
- 24 TextColumn Property
- 23 Adding Comments II
- 22 Adding Noncontiguous Cells
- 22 Filter on Color/Colour
- 22 Cell Master
- 18 OpenOffice Blog
- 18 JMT QA Board Syndicated
- 17 Adding Comments
- 16 How to Spread Bad Habits
- 16 Programming Language of Choice
- 15 March Madness
- 15 New Web Forum
- 14 The Like Operator in MSQuery
- 10 Charting Goal Seek
- 10 Basing One Listbox on Another
- 10 WEIBULL
- 9 Support Classic VB
- 9 More Fill Handle Secrets
- 7 Blog Menu Changes
- 7 Censorship
- 7 Angled Column Heading
- 4 Two Type Charting
- 4 Calculating Two ATP Functions in the Formula Bar
- 3 Most Honorable Excel Guy
- 1 INDIRECT and Dynamic Ranges
February 2005
- 28 WordPress Upgrade
- 28 Browser Links
- 25 Searching Files in Subfolders for VBA code string
- 24 Hardcore VB
- 23 HTML in Cells II
- 22 What’s On Your Bookshelf
- 21 The Switch function
- 19 Comment Control
- 19 Book review - Excel 2003 Programming, A Developer’s Notebook
- 18 Power User Setup
- 17 Week numbering without Analysis ToolPak
- 17 Limit a Listbox (Another approach)
- 17 Bulk Uploads using ADO Command Parameters
- 16 Limit a Listbox
- 15 Workday Function
- 14 New Blog Tracking
- 14 Extending Formulas
- 12 Pragma Utilities
- 11 I’ve Got My Copy
- 10 Mouse Habits
- 10 Custom CommandbarButton Faces in VBA
- 9 Comment Spam Again
- 9 Andrew’s Utilities v2
- 9 SuperXL
- 8 Import Text in VBA
- 7 Five Thirty Eight
- 7 Comment Spam
- 4 Go Back!
- 4 Summing Text
- 3 Parse Names with Outlook Array Formula
- 2 Data Validation and Hyperlinks
- 1 Freezing Column or Row Headers
January 2005
- 31 Using ADO in Functions
- 29 For Next Behaviour
- 28 Parsing SQL
- 27 Avoiding the System Clock
- 27 Professional Excel Development - Sample Chapters
- 26 Range Areas
- 25 Automation in UDFs
- 24 EasyFilter 2.0
- 24 Book review - Excel Annoyances
- 23 Back to the Grind
- 23 Week Numbers
- 20 What makes a good book?
- 19 Hitting the Slopes
- 18 SheetSwitcher AddIn
- 18 Frank Kabel
- 17 An Array of Column Letters
- 16 Union and Intersect
- 15 Book Review: Excel Hacks
- 15 Surface Chart 3D Terrain Generator
- 14 Undiscovered Excel Tips
- 13 Charitable Contributions and IRR
- 12 Andrew’s Utilities
- 11 Emailing Pictures in the Mail Body
- 11 Updated FormFun example
- 10 Entering Long Array Formulas in VBA
- 9 You Buy PUP6 Now
- 8 Year End Woes
- 7 Tiling Windows
- 6 Formatting Footers in VBA
- 6 Magic Colon
- 5 I’m a Geek
- 5 Performance hit of Statusbar
- 5 Immediate If
- 4 Update To PopupMenu
- 4 Naming a Sheet Based on a Cell
- 3 Comparing Numbers
December 2004
- 30 Three Happiness Online Poker
- 30 Football Pool
- 29 Non-Excel Object Models
- 28 ShellExecute
- 27 Show PowerPoint Slides on a Form
- 26 Calculating with the selected range
- 25 Author Update
- 24 More Office Poems
- 23 Excel Viewer 2003
- 22 Functions that do things
- 22 Replacing the Analysis Toolpak Addin - Part 4
- 22 Page Of Pages in a Cell
- 22 Outputting Worksheet Comments
- 21 Private Test Post
- 21 PUP6 Released
- 21 Thoughts on Arizona
- 20 Replacing the Analysis Toolpak Addin - Part 3
- 19 Replacing the Analysis Toolpak Addin - Part 2
- 18 Replacing the Analysis Toolpak Addin - Part 1
- 16 Sunny Arizona
- 16 ADO Recordset Basics
- 16 Concatenating and splitting strings
- 15 Counting Items in a Comma-Separated List
- 15 String manipulation with worksheet formulas - Part 2
- 14 Pivoting on Two Fields
- 13 Parameters in Excel external data queries
- 13 TechTrax
- 11 Excel VBA Language Reference
- 11 Google Desktop
- 10 PopupMenu
- 10 Help Combobox
- 9 New Features
- 9 Selection Stats
- 8 Add a Description to an Add-in
- 7 Favorites Menu
- 7 EasyFilter Add-in
- 7 Using Copy/Paste in userforms
- 7 String manipulation with worksheet formulas - Part 1
- 7 Corners of a Large Selection
- 6 String Function Efficiency
- 6 Cycling Window States
- 6 Add or Change Macro Shortcuts
- 5 Site Statistics
- 4 Weekend Picks
- 4 Logical operations in array formulas
- 3 Getting Text From the Windows Clipboard
- 2 Putting Text Into the Windows Clipboard
- 2 The String Function
- 2 Where’s the innovation?
- 2 Referring to Previous Sheet
- 2 Getting the last value
- 1 INDIRECT and closed workbooks
- 1 Disabling Macros on Startup
- 1 International Issues
November 2004
- 30 New Authors
- 30 Alerts When Sharing and Unsharing
- 30 ActiveX Fonts in 2003
- 30 Battleships
- 29 Arrays in Arrays
- 29 HTML in Cells
- 27 Weekend Picks
- 26 Creating a Simple Pivot Table
- 25 QuickWatch
- 24 The New Keyword
- 24 The Easy Way to Find Right Click Menus
- 23 Finding Right Click Menus
- 23 FaceId Viewer AddIn
- 22 GamesXL
- 22 Advanced Filtering in VBA
- 20 Weekend Picks
- 19 Google Search AddIn Updated
- 19 Advanced Filtering: OR Criteria
- 19 Cell Comments
- 18 Ode To Excel
- 18 Harbinger of Doom?
- 17 I Have Slashdot In My Sights
- 17 AutoFilter
- 16 Creating 413 Web Pages with VBA
- 15 Still Moving
- 12 Switching Servers
- 12 TurboExcel v Goliath
- 12 Changing Text Case
- 11 Parse Names with Outlook
- 10 Determining Excel Version
- 9 Technical Difficulties
- 9 Roll Your Own CSV
- 8 Creating CSV Files
- 8 More Sorting Multiple Columns
- 6 Weekend Picks
- 5 Custom Message Boxes
- 5 Returning Errors from UDFS
- 4 Side-by-side Windows
- 4 Menus on Userforms
- 3 Movin’ On Up
- 3 Selecting TextBox Text
- 2 Storing Custom Userform Controls
- 2 Tabs Under File New
- 1 Blog Readers Choice Awards Revisited
- 1 Automating Project
October 2004
- 30 Weekend Picks
- 29 Ignore Blanks in a Formula
- 29 Controls Move When Printed
- 28 Password Protecting Files for Opening and Modifying
- 28 Custom Tear-away Toolbars
- 27 Navy Day
- 26 Showing a UserForm from the VBE
- 26 SetParent
- 26 ShowWindow
- 25 FindWindow
- 25 Incrementing Invoice Numbers with a Text File
- 23 Weekend Picks
- 22 Determine If Cell is Hidden in VBA
- 22 Integer Division
- 21 Blog Readers Choice Awards
- 21 Creating Help Files
- 21 FollowHyperlink and Web Toolbar
- 20 More Checkboxes on Worksheets
- 20 Counting Blocks
- 19 Office Automation Ltd.
- 19 Line Breaks in Formulas
- 19 Checking Grammar
- 18 How to Start a Formula
- 18 Repeating Rows and Column on a Print Out
- 16 Weekend Picks
- 15 Free X1 Software for Me
- 15 Linking Userforms and Worksheets: Part VI
- 15 Code Libraries
- 14 Opening Different File Types
- 14 UnDockable Toolbars
- 13 Module Size Limits
- 13 Toggling Toolbar Buttons
- 12 NETWORKDAYS Holiday “Errors”
- 12 Pixilation Part III
- 11 More Registry Stuff
- 11 Storing Data in the Registry
- 9 Weekend Picks
- 8 New Home for Daily Dose?
- 8 Creating Folders
- 7 Limiting a Range for Looping
- 7 Intersecting Ranges
- 6 Adding ActiveX Controls to Worksheet in VBA
- 6 VLOOKUP with a Variable Column
- 5 WebBrowser Control
- 5 Retail Pricing
- 4 Spreadsheet Errors
- 4 Unofficial Microsoft Office Stuff
- 2 Weekend Picks
- 1 InternetExplorer Object on MSDN
- 1 GetOpenFilename in a Loop
- 1 Ampersands in CommandBarControls
September 2004
- 30 International Relations
- 29 FUNCRES.XLA
- 29 More MINIF Examples
- 28 Classes: Creating Custom Objects
- 27 OfficeUpdate Gripe
- 27 Ask to Refresh
- 27 Splash Screen
- 25 Weekend Picks
- 24 Devil Cat
- 24 Daily Dose Programming Notes
- 24 The Userform Toolbar
- 24 The WorksheetFunction Method
- 23 Happy Equinox
- 22 Automating Internet Explorer
- 21 Quickly Hiding Columns
- 20 Linking Shapes to Cells
- 18 Weekend Picks
- 17 Inserting Rows
- 16 Printing Certain Pages
- 16 Creating Custom Icons
- 15 Excluding Collection Members
- 15 Array Functions
- 15 Data Table Basics
- 14 Word Match Game
- 14 Played The West
- 11 Weekend Picks
- 10 Play The West
- 9 Autofilter and Subtotal
- 9 Formulas, Formats, and Shortcuts
- 9 Linking Userforms and Worksheets: Part V
- 8 Accumulating Visible Cells
- 8 Linking Userforms and Worksheets: Part IV
- 8 Yet Another Bug
- 7 Quick Date Entry
- 4 Weekend Picks
- 3 Linking Userforms and Worksheets: Part III
- 3 Linking Userforms and Worksheets: Part II
- 3 Linking Userforms and Worksheets: Part I
- 2 Determine If Event Exists
August 2004
- 31 Disabling Startup Macros
- 30 Rounding Time
- 27 Long vs. Integer
- 27 Double Underline
- 26 Roll Up Piano
- 26 Disabled Toolbar Buttons
- 26 Finally, I’m One of the Beautiful People
- 25 The Analysis Toolpack
- 25 Using Row() in Array Formulas
- 24 Principal Payments Through a Certain Date
- 23 Copying Custom Formats
- 23 Sheet Names in a DropDown on a Toolbar
- 20 Excel VBA Programming for Dummies
- 20 Server Troubles
- 19 Controlling Headers and Footers
- 19 The Birthday Formula
- 19 Different Formula, Same Result
- 18 Running Macros When a Workbook is Opened
- 18 PrintThru Email
- 17 Data Non-Validation
- 17 Graphing Web Data
- 16 Summing Odd Numbers
- 16 Watermarks
- 16 Incorrect Sorts
- 13 Pixilation Part II
- 13 Automating Word
- 12 Building Formulas2
- 12 Testing For Empty Cells
- 12 Controls: Snap To Grid
- 11 Precision
- 11 Controls: ActiveX vs. Forms
- 10 Grouping Option Buttons
- 10 A Lovely Ceremony
- 4 Meet Me In St. Louie, Louie
- 4 Building Formulas
- 4 Digital Clock
- 3 Summing in 3D
- 3 Text To Columns
- 3 Replace97 Bug Report
- 2 Spellcheck a TextBox
- 2 Combining Arrays
July 2004
- 30 The OnTime Method
- 30 +/- In a Number Format
- 28 Fun Facts
- 27 Interviews (Again)
- 26 Sorting Items in Outlook
- 23 Bitwise And
- 22 Passing Arguments to a Userform
- 22 The Best Man
- 21 Pixilation
- 21 Creating Outlook Appointments in a Non-default Folder
- 20 Custom Enumerations
- 20 BUG: MultiPage Controls on 2003
- 19 Ordinal Days
- 19 NETWORKDAYS
- 16 Custom Document Properties
- 15 Interviews
- 15 User Defined Types
- 14 Nested Functions
- 14 Wireless Encryption Codes
- 14 Now That’s Service
- 13 Inverting The Selection
- 12 Userform Design Best Practices
- 12 Working in RefEdit Controls
- 9 Rotating Text
- 8 Hiding Formulas
- 8 ListBox Scrolling
- 7 Entering Dates In Textboxes
- 7 The (st)Range Object
- 6 Userforms: MultiPage Controls
- 6 Tab Order of Cells
- 2 Another Birthday
- 2 Better Solutions
- 2 PlanMaker
- 1 Count Array Dimensions
- 1 Userforms: SpinButton Control
June 2004
- 30 Dynamic Data Validation
- 30 Parsing Names
- 29 Preserving ListBox Selections
- 29 Finding the Root
- 29 MAXIF, MINIF functions
- 28 Timing Macros
- 28 Redim an Array
- 28 Closer to Death
- 25 Fixed Decimal Places
- 25 Updating Values En Masse
- 25 Speed Up Your Code
- 24 “Nearly” Daily Dose
- 23 Sort On More Than 3 Columns
- 23 Ugly Formulas
- 22 Progress Bar
- 22 Volatile Functions
- 22 Copying Formulas
- 21 A Couple of Links
- 21 Summing in the Status Bar
- 21 Classes: Other Events
- 21 Conditionally Formatting Number Format
- 20 Sunday Link
- 18 ISNONTEXT
- 18 Classes: CommandBarButton Events
- 18 SEARCH And FIND
- 17 College World Series
- 17 Get the UserName in VBA
- 17 200th Post
- 16 Fuzzy Text Match
- 16 BeforeClose vs. BeforeReallyClose
- 16 Amortization Table
- 15 Mastermind
- 15 Named Formulas
- 15 AND and OR Functions
- 15 Classes: Application Events
- 14 Move Up/Move Down in a ListBox
- 14 Sheet Name
- 14 Retrieve Values From a Multi-Column/Select ListBox
- 13 Sunday Link
- 11 Retrieve Values From a MultiColumn ListBox
- 11 Dynamic Named Ranges
- 11 Hightlight Cells With Formulas
- 10 Out With The Old…
- 10 Named Constants
- 10 DisableControls
- 10 GetSaveAsFilename
- 9 GetOpenFilename
- 9 GetNextCell
- 9 Clear the Immediate Window
- 8 Disabling Events In Userforms
- 8 Summing Every Nth Row
- 8 Count of Visible Workbooks
- 7 The Planning Deskbook
- 7 Simulating a LIKE function
- 7 Column Letters To Numbers
- 7 Nothing Keyword
- 6 Sunday Link
- 5 Feliz Aniversario
- 4 Windows In The TaskBar
- 4 Securing Your VBA Code
- 4 Populate a MultiColumn ListBox From an Unsorted Range
- 4 Explicit Conversion Functions
- 3 External Data - Mixed Data Types
- 3 Look It Up
- 3 Passing Arguments Through OnAction
- 2 Making the Best Choice II
- 2 Sort a Collection
- 2 Add New Column to External Data
- 2 Shoot The Bird
- 1 Cell Precedents
- 1 BlackJack in Excel
- 1 Column Widths In Points
May 2004
- 31 Flying the Flag
- 30 Sunday Link
- 28 Excel Game Links
- 28 Changing the Cursor in VBA
- 28 Tabbing In A TextBox
- 27 Printing Multiple Sheets
- 27 Nesting With Statements
- 27 GetCreateAutomationObject
- 26 Validating an InputBox
- 26 ExtractPath
- 26 Navigate a Recordset With a Userform - Part IV
- 26 ExtractFileName
- 25 Navigate a Recordset With a Userform - Part III
- 25 Think Again
- 25 Finding Wildcards
- 25 Navigate a Recordset With a Userform - Part II
- 24 Navigate a Recordset With a Userform - Part I
- 24 Sorting a MultiColumn ListBox
- 24 Data Validation - ALL CAPS
- 23 Sunday Link
- 21 Commandbar Exists
- 21 Column Numbers To Letters
- 21 INDIRECT Worksheet Function
- 21 Setting the Print Area with VBA
- 20 Custom Commandbars
- 20 Join97
- 20 Split97
- 20 Replace97
- 19 Counting Characters
- 19 Password Characters
- 19 Address of a Matching Cell
- 18 SheetExists
- 18 Updating a Sheet
- 18 Making the Best Choice
- 18 Listing Unique Items With Collections
- 17 Finding Character 10
- 17 Deleting Cells in a Loop
- 17 Reposition Table
- 16 Sunday Link
- 14 If My Head Gets Any Bigger…
- 14 Workbook Exists
- 14 File Exists on Disk
- 14 VBA Code Library
- 14 VBA To HTML
- 13 Remembering Telephone Numbers
- 13 Lost Stop Recording Button
- 13 Count Unique Days
- 12 Sorting ListBoxes
- 12 Moving Data Between ListBoxes
- 12 Circular References - The Good Kind
- 11 Green Triangles
- 11 Deselect Listbox
- 11 Conditional Data Validation
- 10 Rounding Worksheet Funtions
- 10 Scroll Wheel in the VBE
- 10 Populating Multi-Column ListBox/ComboBox
- 9 Sunday Link
- 7 Populating One-Column ListBox/ComboBox
- 7 VBE Navigation Shortcuts
- 7 Versioning From rzf
- 6 Cell Protection
- 6 Refresh a Browser Window
- 6 Counting With Array Formulas
- 5 Opening Excel Files From Windows Explorer
- 5 Credit Card Numbers
- 5 CheckSpelling Bug
- 4 Blog Tracking
- 4 Sum Visible Rows
- 4 Beginning VBA: Advanced Functions
- 3 Sum Last Three Golf Scores
- 3 Code Critic Revisited
- 3 Beginning VBA: Events
- 2 Sunday Link
April 2004
- 30 War Heroes
- 30 Translating Text
- 30 Family Honors
- 30 Entering Dates Into Cells
- 30 Showing Ampersand (&) in Header
- 29 Beginning VBA: Common Objects, Properties, and Methods
- 29 Formatting ratios
- 29 Crossfooting
- 28 Creating Hyperlinks
- 28 Snapshot of an Excel Range
- 28 Beginning VBA: Navigating the Object Model
- 27 Recently Used Files
- 27 Using Multiselect Listboxes
- 27 Beginning VBA: Select and Activate
- 26 Windows Noise
- 26 New Excel Blog
- 26 Data Range Properties Options
- 26 Beginning VBA: Recording Macros
- 25 Sunday Link
- 24 Code Critic
- 23 Startup Templates
- 23 Crappy Songs
- 23 Beginning VBA: Objects, Properties, and Methods
- 22 Stevie Nicks Fans?
- 22 Closing a Workbook Without a Prompt
- 22 Beginning VBA: Your First Function
- 21 Breathing Underwater
- 21 Small Beer
- 21 Avogadro’s Number
- 21 Desirable Women
- 21 JWalkBlog Anonymous
- 21 Hyperlinking to a Word Bookmark
- 21 Save File with Date
- 21 Beginning VBA: Your First Macro
- 20 The Me Keyword
- 20 Where To Find Answers
- 20 Beginning VBA: The Visual Basic Editor
- 19 Proper Case in VBA
- 19 Copy Subtotals Only
- 19 The Envelope Please…
- 18 Sunday Link
- 17 Navigation Tips
- 16 Worksheet Formula in VBA Part II
- 16 I’m Turning Japanese
- 16 Worksheet Formulas in VBA Part I
- 15 Tax Day Ruminations
- 15 The Dir Function
- 14 Copying Sheets
- 14 Ready, Set, Startup
- 13 Compiling Excel VBA
- 13 Madame Butterfly
- 13 Conditional Formatting Corrupts Absolutely
- 12 Two Lines, No Waiting
- 12 Matchmaker
- 11 Sunday Link
- 10 Mmmm… Pi
- 9 The Excel Word Challenge
- 9 Back In the Saddle
- 8 Doppleganger
- 7 The First Shall Be Last
- 6 Wheres my 14.4 modem?
- 6 The Taxman Cometh
- 5 Death By Acronym
- 5 Anatomy of an Array Formula
- 4 Sunday Link
- 3 The Mothership Is Calling Me Home
- 2 Seek and Ye Shall Find
- 2 Making the Grade
- 1 Invisible Ink
- 1 The Case of the Missing Page Break
- 1 Old Fashioned Conditional Formatting
March 2004
- 31 …and other stuff
- 31 Crosses and Naughts
- 31 Excel Knows Best
- 31 Pick a Winner
- 30 Excel Charts for Smart People
- 30 Excel Charts for Morons
- 30 Secrets of the Fill Handle
- 29 The Find Method
- 29 SUMIF Between Two Dates
