Learn how to create an Excel drop down that shows suggestions as you type. A step-by-step tutorial to create an Excel Drop Down List with Search Suggestions| Trump Excel
Sometimes you may have the need to highlight the active row and column in a data set. Learn how to do this easily in Excel.| Trump Excel
Here is a simple VBA code that can be handy when you have to combine multiple Excel files into one single Excel workbook...| Trump Excel
Finding a way to reuse R/W/X memory with VBA and how to avoid crashes| VBA: overwriting R/W/X memory in a reliable way |
There seem to be more cases recently where the VBA in a workbook gets corrupted and is removed when the workbook is reopened. Circumstances Nobody seems to know exactly why this happens but there there do seem to be one … Continue reading →| Excel and UDF Performance Stuff
Article describing an alternative method to trigger shellcode execution| VBA: having fun with macros, overwritten pointers & R/W/X memory |
Combination of small snippets of code to simulate getprocaddress avoiding dangerous functions| VBA: resolving exports in runtime without NtQueryInformationProcess or GetPro...
Because Python calculations can be slow it is worth looking at ways of controlling Python calculation. Partial Calculation The calculation setting that used to be called “Automatic except Dat…| Excel and UDF Performance Stuff
The problem The gist of the matter is that some Excel macros started causing extreme memory leaks when used in version 2013 and later. My first searches online yielded results instructing to avoid copying and pasting, to disable calculations for the duration of the macro etc. I’ve done all I possibly could based on those results, but the issue persisted.| Stuff from here and there