H
hjbrooks2002
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
(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