Excel Hide Column

[RickB75 4]

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?

[water 1,771]

Google returns something like this to hide column B: ActiveSheet.Range("B1").EntireColumn.Hidden = True

[RickB75 4]

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.

[water 1,771]

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!