Auto Filter controled by a macro - simple question!

All,

I'm trying to set up a macro to to run and control the AutoFilter in my Excel Spread Sheet. Essentially, all i want to be able to acheive is, instead of inputting the cryteria myself in the auto filter, i want the macro to select the cryteria from a specific cell.

Example...

Running the autofilter, normally you would select "equals or grater than" option and you would input a figure then click the "or" option then input "equals or less than" and a new figure and then click ok. This would sort the range; see the example macro...

' test1 Macro
' Macro recorded 06/08/2007 by Nigel M Bailey
'
Selection.AutoFilter Field:=10, Criteria1:=">=01/09/207", Operator:=xlOr _
, Criteria2:="<=31/09/2007"
ActiveCell.Offset(774, -1).Range("A1").Select
ActiveWindow.SmallScroll Down:=-15
End Sub

What i want to beable to do is to run a macro which will do the above but instead or requiring the user to input the range cryteria for the filter it would point to a cell to get the value from.

' test1 Macro
' Macro recorded 06/08/2007 by Nigel M Bailey
'
Selection.AutoFilter Field:=10, Criteria1:="> Cell A2", Operator:=xlOr _
, Criteria2:="< Cell A3"
ActiveCell.Offset(774, -1).Range("A1").Select
ActiveWindow.SmallScroll Down:=-15
End Sub

In doing this i can validate the selection field and just add a search button which then will be perfect!

Is this possible to do?

Something like

Please Login or Register  to view this content.

Can you attach a small example?

Do you mean the date format is changing?

Try

Please Login or Register  to view this content.

Originally Posted by NigelMBailey

Progress!

Now i have fixed the input cells and they are beig carried forward to the autofilter selection cryteria sheet. However it is showing nothing. But if i look at the custom filter it is showing the correct values in each and when i just click ok it then shows the correct values filtered......

How can it force a recalculate in the macro.>?

Please Login or Register  to view this content.

I don't know what this might be, possibly if you attach the workbook I might get a better idea.