Erlandsen Data Consulting
Erlandsen Data Consulting
VBA Tips
(current)
(current)
About EDC
Om EDC
Cookies
Search this site
Recent
Addins
Application
Charts
Commandbars
Count
Dates
Dialogs
Events
File access
Files & Folders
Functions
Games
Help
Import & Export
Lookup
Off topic
Other
Outlook
PivotTables
Printing
Problem solving
Read me
Sorting
Sound
Strings
Sum
Time
VBA programming
VBE
Workbooks
Worksheets
Recent VBA Programming Tips & More
Updated
Chart numberformat space bug
2019-06-28
About the examples and tools on this site
2019-03-09
Custom shortcut menus
2018-06-27
Zip codes and names for Norway
2017-05-04
Convert number to text
2017-04-29
Disable the Tools Pane in Adobe Acrobat Reader
2017-04-10
Using input from named worksheet cells in Workbook Queries
2017-03-15
Delete all items in the Outlook Junk and Trash (Deleted Items) folder
2017-01-10
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
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