Recent VBA Programming Tips & More Updated
Move and resize a worksheet shape object to cover a given worksheet range 2016-10-07
Display a progressbar on the statusbar 2016-09-25
Set row height and column width in millimeters 2016-09-08
Office 365: "Sorry, we can't connect to your account. Please try again later" 2014-03-05
Expand all collapsed Outlines and restore them later 2013-08-07
Android: "Your device has been modified." 2013-08-05
Problems with Excel 2010 and the SmartView Addin 2013-02-16
Custom calendar for selecting dates from the user 2012-05-13
Zip codes and names for Norway 2012-03-24
Find PivotTable reports that overlap each other 2012-03-06
Remove duplicate items from a worksheet range 2012-02-08
Save multiple PDF files in shorter time 2011-11-01
Retrieving filenames from a folder 2011-10-29
Import data from multiple workbooks 2011-10-26
Error Message "Data source reference is not valid" 2011-09-21
Retrieve a worksheet based on the worksheet contents 2011-07-21
Retrieve a worksheet based on the worksheet name 2011-07-21
Break links to objects in PowerPoint presentations 2011-07-21
Calculate date differences 2011-07-03
A couple of useful workbook functions 2011-07-02
Getting filenames in other applications than Excel 2011-07-02
Quickly delete rows in a worksheet 2010-10-16
Remove missing PivotField items 2010-05-08
Protect all cells containing formulas in a worksheet 2009-12-17
Change the default printer 2009-09-15
Delay code execution and get elapsed time 2009-09-04
How to run macros in another workbook 2009-07-21
Save persistent settings in a workbook 2009-07-21
Aligning strings within a fixed width 2009-06-05
ADO connection strings 2009-06-04