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,847 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-06-01 - Version 1.4.9.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX (2018-01-27 - Version 1.3.3.1) - 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 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,847 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-06-01 - Version 1.4.9.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX (2018-01-27 - Version 1.3.3.1) - 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
