Hide rows depending on the date
 

Hi all,

This should be easy:

I need to write code which hides a specific set of rows if it happends to be
past a certain date. It is for a group of four tabs which report sales in
each of the four quarters and also inform the staff of where they should be
to quarter based on the date (it's this latter info i want to hide when the
quarter is over so that they can still review the sales, but not get
distracted by the (now invalid) surplus data).

Each tab contains a small list of dates which my target calculations are
powered by and I would like to use these to power the above code if at all
possible

Thanks foir any help!

Hide rows depending on the date
 

This may sound odd, but why don't you use a simple filter ?
Why the need to write code ?

--
Regards;
Mark Rosenkrantz
--
Spreadsheet Solutions
Uithoorn
Netherlands
--
E:
W: www.spreadsheetsolutions.nl
--
"teafan" wrote in message
...
Hi all,

This should be easy:

I need to write code which hides a specific set of rows if it happends to
be
past a certain date. It is for a group of four tabs which report sales in
each of the four quarters and also inform the staff of where they should
be
to quarter based on the date (it's this latter info i want to hide when
the
quarter is over so that they can still review the sales, but not get
distracted by the (now invalid) surplus data).

Each tab contains a small list of dates which my target calculations are
powered by and I would like to use these to power the above code if at all
possible

Thanks foir any help!