Prev: Response to txtbox content if not found in the worksheets: Excel V
Next: sendkeys sends every other letter Excel 2007 to Outlook 2007
From: tina on 15 Feb 2010 07:45
Hi
My advanced filter works manually but not in macro > It is a criteria issue
as column headings work
I am trying to filter data where ship date is <= todays date +28
Columns("g:k").AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=Range( _
"m1:m2"), CopyToRange:=Range("p1" _
), Unique:=False
where m1 = ShipDate
and m2 = <=15/03/2010

this works manually but not in macro but if replace m2 with a date it works
therefore how do i write for less than and equal to
Thank you
Tina
From: tina on 15 Feb 2010 07:59
Hi
I worked out date has to be mm/dd/yy format
Sorry if wasted anybodies time
Tina

"tina" wrote:

> Hi
> My advanced filter works manually but not in macro > It is a criteria issue
> as column headings work
> I am trying to filter data where ship date is <= todays date +28
> Columns("g:k").AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=Range( _
> "m1:m2"), CopyToRange:=Range("p1" _
> ), Unique:=False
> where m1 = ShipDate
> and m2 = <=15/03/2010
>
> this works manually but not in macro but if replace m2 with a date it works
> therefore how do i write for less than and equal to
> Thank you
> Tina
 | 
Pages: 1
Prev: Response to txtbox content if not found in the worksheets: Excel V
Next: sendkeys sends every other letter Excel 2007 to Outlook 2007