Macro, autofilter, delete rows outside date range, defined names as criteria

**rain4u** · 04-25-2011, 07:58 PM

Hi. I have two named cells that contain dates:

Please Login or Register  to view this content.

I would like to have a macro using auto filter to delete rows that do not fall between those dates. Monday as start date and Friday as end date (both inclusive). Maybe this code below that I found on the Internet can be adjusted to do this task:

Please Login or Register  to view this content.

This code above prompts with input window box to allow user to manually write the dates but remember I would like to use named cells instead.

Any ideas

Cheers
Rain

**nimrod** · 04-25-2011, 08:12 PM

What column are the dates in ? Is the sheet the activesheet ? Do you have a header row that should be excluded from inspection ?

**rain4u** · 04-25-2011, 08:17 PM

Yes I forgot to mention these details. Active sheet, column 9 ( or column col i) and it does have header row (row1).

Cheers
Rain

**rain4u** · 04-27-2011, 12:33 AM

*bump*bump*

**nimrod** · 04-27-2011, 11:25 AM

Assumptions:
-- All values in Column "i' , except for row 1, are dates

Please Login or Register  to view this content.

**rain4u** · 04-30-2011, 04:10 AM

Thx Nimrod. It works. I also learned from your code. If someone else needs to get the same result but get it by using autofilters then the following would do the job

Please Login or Register  to view this content.

Cheers
Rain

Macro, autofilter, delete rows outside date range, defined names as criteria

LinkBack

Thread Tools

Rate This Thread

Display

Macro, autofilter, delete rows outside date range, defined names as criteria

Re: Macro, autofilter, delete rows outside date range, defined names as criteria

Re: Macro, autofilter, delete rows outside date range, defined names as criteria

Re: Macro, autofilter, delete rows outside date range, defined names as criteria

Re: Macro, autofilter, delete rows outside date range, defined names as criteria

Re: Macro, autofilter, delete rows outside date range, defined names as criteria

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions