Prev: Open Multiple Files At Once
Next: Print all open files
From: Gord Dibben on 27 Apr 2010 11:18
My testing was on 2003.

I have since tested on 2007 and found that you get different results
depending upon how you filter.

Selecting from the list you get

ActiveSheet.Range("$A$1:$A$22").AutoFilter Field:=1, Criteria1:=">60 days"

Selecting from Custom>Equals you get

ActiveSheet.Range("$A$1:$A$22").AutoFilter Field:=1, Criteria1:="=>60 days"

2003 treats both methods the same and returns in both cases

ActiveSheet.Range("$A$1:$A$22").AutoFilter Field:=1, Criteria1:="=>60 days"



Gord

On Mon, 26 Apr 2010 15:43:02 -0700, OssieMac
<OssieMac(a)discussions.microsoft.com> wrote:

>In Excel 2007 the macro recorder does not return the equal sign. The
>following is what I get with the macro recorder. I have not tested in any
>other versions.
>
>ActiveSheet.Range("$A$1:$B$835").AutoFilter Field:=2, Criteria1:= _
> "> 60 days past due"
>
>And of course the above does not work without the leading = sign when the
>code is run.

First  |  Prev  | 
Pages: 1 2
Prev: Open Multiple Files At Once
Next: Print all open files