Code error “wrong number of arguments or invalid property assignment”

What is wrong with this bit of code?

Please Login or Register  to view this content.

It points at an error in this line of code with error “wrong number of arguments or invalid property assignment”

Please Login or Register  to view this content.

Appreciate any help. Example attached.

Thanks MarvinP

I got this to do what I want using the below

Please Login or Register  to view this content.

but i would like to build on this and have something like the below but I keep getting an error “wrong number of arguments or invalid property assignment”. So I thought it might be a syntax issue? The code below I believe is possibly better it that I am trying to use Variables, which would be better long term for the code

Please Login or Register  to view this content.

Could it be you are looking for "A" in pivotfields(1) which is the Date?

I have fixed this now

This might cause the error as dates and text are different?

I am not looking at dates here, but I will be in another MACRO that I am working on

Also does .ColumnsFields work? ColumnsFields is really PivotFields(2) ?

I have fixed this now

Thanks again