Thread: Hiding Columns
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Andy the Yeti Andy the Yeti is offline
external usenet poster
 
Posts: 28
Default Hiding Columns

Is there a piece of VBA code that will allow me to run a macro at a push of a
button that will hide or unhide columns in a workbook dependant on a given
criteria in say row A ?
For example if columns A, B, C & F, & H has a €œ1€ in then leave and if
columns D, E, & G has a €œ2€ then €˜hide ?

Many thanks

Andy