Excel & AutoHotkey-Replacing Null values in Excel

Replacing Null values in ExcelWhen some programs export data they will insert #Null! into a cell to indicate there was no data (SPSS to name one).  While I would rather have something than nothing, when trying to compute averages or share data with clients the #Null! value is not ideal.  🙁  In this tutorial I demonstrate how easy it is to Replacing Null values in Excel with AutoHotkey.

The following video demonstrates Replacing Null values in Excel.  While I didn’t show the entire code in the video, it is below for your reference.

Excel & AutoHotkey-Replace Null / Missing values

 

AutoHotkey Function for Replacing Null values in Excel

 

Adding / Manipulating / Clearing Borders in Excel with AutoHotkey

Borders in ExcelIn this tutorial I show how to add / remove / edit Borders in Excel with AutoHotkey.   Below is the code I use to apply the changes.  Be sure to review this if you’re unfamiliar with connecting to Excel via a COM object,

Function for working with Borders in Excel

Here is the video where I walk through using the function to play with Borders in Excel

Excel & AutoHotkey-Adding & Removing Borders