Thread: Macro for hiding all rows accept those selected by a dated column?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Doug Doug is offline
external usenet poster
  
Posts: 460
Default Macro for hiding all rows accept those selected by a dated column?
Column A has dates in Descending order. I am wanting to hide all but a
predefined date range. So if there are dates in rows 5 through 300 and I want
to see only a week from today, it will show 5 weekdays starting with row 5. I
would like to do this also for 1 month, 3 months, 6 months, & 1 year. Can you
help me construct a macro please?
--
Thank you!
Reply With QuoteReply With Quote