Do loop not running

Hi there

Appreciate any help as I am building on from this post here
I have the below bit of code that I want to go through my pivot chart and make the last 7 days of data visible.

I am having trouble with the Do loop. When I comment out the Do loop it runs okay. When I add the Do loop it dosen’t do the Do loop.

Can anyone suggest anything?

Here I am assuming that the date 07/09/2011 is the only date visible in the pivot chart. So when I run this macro the 11/09/2011 will also be visible in the pivot chart.

When I get the do loop working I hope to have the 11th to the 18th visible( it is still in early stages so a bit of fine tuning needed also)

Please Login or Register  to view this content.

Lastdate7 is set to be 7 days less than lastdate
Your Do loop does not action because lastdate7 is already less than lastdate