Here I show you how to get columns from Excel and and AutoHotkey. You can easily get the first column used, last column used, used range, etc.
Microsoft’s Component Object Model enables AutoHotkey to easily interact with Excel! In the below video I used the following functions to obtain First, last and Used columns from Excel via AutoHotkey. I also demonstrate a few additional functions which allow for easily converting letters to numbers and vice versa. This makes it easier to program in Excel because you can reference “column M” instead of column 13.
How to get Columns from Excel and AutoHotkey
Here are the functions which make it super easy to grab / set columns in Excel