help needed linking to a cell to obtain date

[debesh_b]

This is my code...

ActiveSheet.Range("$A$5:$P$9998").AutoFilter Field:=12, Criteria1:= _
">=7/01/2008", Operator:=xlAnd, Criteria2:="<=09/30/2008"

Now my dilemma is i have 2 cells, (Data!b6 and Data!b7), containing dates.

I want Criteria1 to to be >=Data!b6 and I want Criteria2 to be <=Data!b7. It seems simple enough but I cannot get it working.

The other problem is the cells containing dates are coded as dd/mm/yyyy (being in Australia), while VBA is reading the dates mm/dd/yyyy.

Does anyone have any idea on how I can get this working?

Thanks.

[royUK]

Please read the Forum rules then edit your post to add Code tags

[debesh_b]

Sorry Roy,

Here is my code with tags ( couldn't see an edit button for my above post)...

Please Login or Register  to view this content.

Anyone have any ideas? Much appreciated. CHeers.