PC Review


Reply
Thread Tools Rate Thread

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
 
Reply With Quote
 
 
 
Reply

Thread Tools
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


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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:19 AM.