Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
A macro that will hide all but the last 20 dated rows. Mac0001UK Excel Discussion (Misc queries) 1 September 19th 08 08:45 AM
Color alternate rows when after hiding selected rows Monk[_2_] Excel Worksheet Functions 6 June 7th 08 01:36 AM
Dependent dropdown query - hiding items selected in prior column Juliet Excel Programming 5 April 1st 08 09:51 PM
Hiding and displaying selected rows programatically BGC Excel Programming 0 March 25th 08 11:31 PM
Macro to place dated rows in email and send??? PG Oriel Excel Programming 1 October 11th 06 11:05 AM


All times are GMT +1. The time now is 01:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"