VBA to update pivot tables date between value - Date error

retty much a VBA novice, I am trying to update date filter on 3 Pivot tables that have been grouped by Date to Month/year, I want to make it dynamic so that start and end date can be updated

I have written the code below but get an invalid date error when try to run it

if I change line with Type:=xlDateBetween, Value1:=Range("StartDate"), Value2:=Range("EndDate")
to
Type:=xlDateBetween, Value1:="01/09/2012", Value2:="31/08/2013"

it works fine. The cells that I reference are in the same format as above.

Any help would be appreciated

Please Login or Register  to view this content.