Recent VBA Programming Tips & More Updated
Functions to determine if a date is a workday (Power Query) 2023-06-23
Function to determine the date for Easter Sunday (Power Query) 2023-06-23
Sorting data using VBA 2023-06-04
Sorting data using VBA: Using the SORT worksheet function 2023-06-04
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: 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