View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Todd[_6_] Todd[_6_] is offline
external usenet poster
 
Posts: 3
Default macro to hide column based on header

I've been using auto filter to hide unwanted columns and
rows. I tried recording that as a macro but it is doesn't
work to well. I need a better macro that would hide
columns where the header is "Inactive" or the row
contains "XXX". Can anyone help?


Todd