date filter for yesterday and today

Riensn

Guest

Posts: n/a

25th Jun 2009

Hi,
sorry I guess thats very easy for you but I dont know how to do it.

I would like to filter for yesterday and today.

At the moment I am only filtering for yesterday:

ActiveSheet.Range("$A$1:$CL$8641").AutoFilter Field:=1, Criteria1:= _
xlFilterYesterday, Operator:=xlFilterDynamic

What do I have to add so that that it filters for both days?

Thanks
Thomas

« Import from another file | Code Works Fine in Excel 2007, Excel 2000 generates Runtime Error 438 »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Date: Today Date: Yesterday etc.	katie	Microsoft Outlook	1	19th Jun 2006 04:10 AM
Inbox - Sort - Date: Today Date: Yesterday	Jan Groshan	Microsoft Outlook	2	24th Apr 2006 09:23 PM
How do I compute yesterday's business date if today is Monday	Dave	Microsoft Access Queries	4	16th Feb 2006 04:46 PM
Missing Today & Yesterday in Inbox arranging by Date	=?Utf-8?B?ZmM=?=	Microsoft Outlook Discussion	0	18th Dec 2005 12:02 AM
Date: Today, Yesterday, Last Week -- How do I get rid of these?	hmc	Microsoft Outlook	2	12th Apr 2005 10:22 PM