RickB75 4 Posted November 20, 2012 I've been searching trying to find a thread on how to have Autoit to hide a column in excel. I can't find the answer anywhere. Do any of you guys have a clue on how to do this? Share this post Link to post Share on other sites
water 1,936 Posted November 20, 2012 Google returns something like this to hide column B: ActiveSheet.Range("B1").EntireColumn.Hidden = True My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2018-12-03 - Version 1.4.11.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX (2018-10-31 - Version 1.3.4.1) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsPowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & SupportExcel - Example Scripts - WikiWord - Wiki Tutorials:ADO - Wiki Share this post Link to post Share on other sites
RickB75 4 Posted November 20, 2012 Water.... That works perfect! I just added the workbook $oExcel and my column range and it works perfect! $oExcel.ActiveSheet.Range("M1:O1").EntireColumn.Hidden = True Thank you. I did search google but I guess I was using the wrong search terms. Share this post Link to post Share on other sites
water 1,936 Posted November 20, 2012 Glad it works for you I simply was looking for "excel hide column visual basic". If you search for visual basic you'll find a lot of code. It's easy to translate to AutoIt! My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2018-12-03 - Version 1.4.11.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX (2018-10-31 - Version 1.3.4.1) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsPowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & SupportExcel - Example Scripts - WikiWord - Wiki Tutorials:ADO - Wiki Share this post Link to post Share on other sites
