Hiding rows based on cell value

  • Thread starter Thread starter Dick
  • Start date Start date
D

Dick

I have a spreadsheet with a column of dates. I need to write code to
hide all rows that are outside of a range of dates that I input as a
"start date" and "end date" via 2 input boxes.
Suggestions?

*** Sent via http://www.automationtools.com ***
Add a newsgroup interface to your website today.
 
One simple answer would be to use a 'helper' column at the end with a formula
that looked at the dates and based on your criteria either returned an OK or
HIDE. Then just do Autofilter on that column selecting OKs. The HIDE value
would prompt you to redo the filter if dates changed.
 
If you pass the 2 dates, as Strings, to 2 variables you could then use
them as the criteria in an AutoFilter.

Excel Templates Training & Add-ins
 
Back
Top