RickB75 4 Report post 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,771 Report post 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 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example ScriptsExcel - Example Scripts - WikiWord - WikiPowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support Tutorials:ADO - Wiki Share this post Link to post Share on other sites
RickB75 4 Report post 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,771 Report post 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 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example ScriptsExcel - Example Scripts - WikiWord - WikiPowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support Tutorials:ADO - Wiki Share this post Link to post Share on other sites