| 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 |