Sub Macro1()
'
' Macro1 Macro
' Macro recorded 24/01/2010
'
'
Sheets("Day").Select
Range("B12").Select
ActiveSheet.PivotTables("PivotTable1").PivotCache.Refresh
ActiveSheet.PivotTables("PivotTable1").PivotFields("DENREG").CurrentPage = Format(Range("A42").Value, "dd/mm/yyyy")
End Sub