macro to hide columns

[Shooter]

My spreadsheet has data in cells A1:G20. I would like to create a macro to
hide columns D, E, F&G. Similarly, I would like to create a macro to unhide
the same columns. I appretiate your help with code to do this.

 

[Ron de Bruin]

Try

ActiveSheet.Range("D1:G1").EntireColumn.Hidden = True

Set it to false to unhide them

 

[Anne Troy]

Shooter: This is a no-brainer that can be recorded. See how to record a
macro here:
http://www.officearticles.com/excel/record_a_macro_in_microsoft_excel.htm
************
Anne Troy
www.OfficeArticles.com