View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
hjbrooks2002 hjbrooks2002 is offline
external usenet poster
 
Posts: 1
Default hiding columns in excel based on formula result

Hi - I am trying to create a macro that will hide columns if date
(that is the column heading) is in the past, i.e. if column heading is
less than "Now()" then hide the column (the spreadsheet application is
a gantt chart of sorts for tracking resource utilization). Do you have
any idea how to do this?

I see lots of links for macros that hide rows or colunns based on
specific values but none for formula results. Please help!! thanks :)