Impossible de définir la propriété currentpagede la classe pivotfied

[HAMADOU]

Bonsoir à tous ! Je suis bloqué sur bout de code depuis quelques jours, j'ai tout essayé mais ça ne donne pas,je vous prie de m'aider.
voilà qui s'affiche "Impossible de définir la propriété currentpage de la classe pivotfied"
d'où le suivant

>>> use code - tags <<<

If Target.Address = "$B$4" Then

   Application.EnableEvents = False
 
      With Feuil9.PivotTables("Table_tcd").PivotFields("[Tableau3].[REF].[REF]")
  
         .ClearAllFilters
         .CurrentPage = Target.Value
       
      End With

   Application.EnableEvents = True
 
End If

 

[vletm]

HAMADOU​

Could You express Yourself in English?

 

[HAMADOU]

HAMADOU​

Pourriez-vous vous exprimer en anglais ?

Good evening everyone ! I've been stuck on a piece of code for a few days, I've tried everything but it doesn't work, please help me. Here it says "Unable to set currentpage property of class pivotfied" hence the following

 

[vletm]

HAMADOU​

I could not find Your named Pivottable from Your file.
... I created a new one for testing.
I modified that Your code ... and it seems to work.
... You seems to use Your 'own' syntax.

 

[vletm]

HAMADOU​

These rules are for You too:

• Cross-Posting. Generally, it is considered poor practice to cross post. That is to post the same question on several forums in the hope of getting a response quicker.
• If you do cross-post, please put that in your post.
• Also if you have cross-posted and get an Solution elsewhere, have the courtesy of posting the Solution here so other readers can learn from the answer also, as well as stopping people wasting their time on your answered question.

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...

chandoo.org

There are also few more sentences which You should reread - Merci.