• Intro to AutoHotkey HotStrings with AutoHotkey Intermediate AutoHotkey GUIs are Easy with AutoHotkey Intro to DOS & AutoHotkey

How to get columns from Excel and AutoHotkey | Obtain First, Last & number columns used

columns from Excel and AutoHotkey

columns from Excel and AutoHotkeyHow to get columns from Excel and AutoHotkey

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

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

  • Intro to AutoHotkey HotStrings with AutoHotkey Intermediate AutoHotkey GUIs are Easy with AutoHotkey Intro to DOS & AutoHotkey