to make a date invisible in pivot chart - macro

[hattrick_123a]

Hi there

I am building on from this here

Attached is the file I am working off.

I have the below macro that basically makes all the dates invisible(i.e. it removes the dates from the pivot chart). I am assuming all the dates are visible.

Please Login or Register  to view this content.

But I get the following error, which is as I understand it to be, because this is the last date that is visible thereby it is not allowed to be made invisible.

Run time error’1004’: Unable to set the Visible property of the PivotItem class

Which points to this bit of code for debug

Please Login or Register  to view this content.

Now what I want to do is make only one date disappear by changing the above code to

Please Login or Register  to view this content.

which gives the following

Please Login or Register  to view this content.

Which gives a compile error: Wrong number of arguments or invalid property assignment

Can anyone help here please?

Specifically, Can anyone suggest how I can make one date invisible as I am trying to do in Sub ShowAllItemsks3() above?

Thanks