Erlandsen Data Consulting
Erlandsen Data Consulting
VBA Tips
(current)
(current)
About EDC
Om EDC
Cookies
Search this site
Recent
Addins
ADO
Application
Arrays
Charts
Commandbars
Count
Dates
Dialogs
Events
File access
Files & Folders
Functions
Games
Help
Import & Export
Lookup
Off topic
Other
Outlook
PivotTables
Power Query
Printing
Problem solving
Read me
Searching
Sorting
Sound
Strings
Sum
Time
VBA programming
VBE
Workbooks
Worksheets
Recent VBA Programming Tips & More
Updated
Create data validation dropdowns based on different input source types, including table columns
2022-08-03
Delete column if it exists (Power Query)
2022-07-29
Functions for calculating ISO year and week number for a date (Power Query)
2022-07-25
Right-aligned menus in the Visual Basic Editor (VBE)
2021-11-05
Translate function names between English and the local language
2021-09-26
Receiving error message "Fixed objects will move" when trying to delete rows
2021-09-16
Install smart home Wi-Fi devices on dual frequency Wi-Fi network (e.g. Google Wi-Fi)
2021-08-22
Excel crashes when opening a workbook using VBA
2021-06-17
Insert a screenshot picture at the active cell
2021-04-29
Replace an existing hard disk with a new one
2021-01-26
Zip codes and names for Norway
2020-08-29
Search in arrays (binary)
2020-07-23
Search in arrays (linear)
2020-07-23
Dictionary object
2020-07-01
Collection object
2020-07-01
Get the local path to a OneDrive folder
2020-06-22
Populating array variables
2020-06-16
Read from and write to multiple worksheet cells using array variables
2020-06-15
Sorting data using VBA
2020-06-14
Sorting data using VBA: Range Sort
2020-06-14
Sorting data using VBA: Table Sort
2020-06-14
Sorting data using VBA: Bubble Sort
2020-06-14
Sorting data using VBA: Quick Sort
2020-06-14
Sorting data using VBA: Shell Sort
2020-06-14
Sorting data using VBA: Merge Sort
2020-06-14
Chart numberformat space bug
2019-06-28
About the examples and tools on this site
2019-03-09
Custom shortcut menus
2018-06-27
Convert number to text
2017-04-29
Disable the Tools Pane in Adobe Acrobat Reader
2017-04-10