Results 1 to 20 of 32

Thread: Pivot Tables: error in 'Field.CurrentPage = NewCat'

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #24
    VBAX Regular
    Joined
    Apr 2021
    Posts
    45
    Location
    Quote Originally Posted by p45cal View Post
    Finally, do you really need to do this on each selection change?
    I would try putting it into the Worksheet_Change event instead.
    Yes that worked, thank you!

    And I've just figured out the difference between selection change and worksheet_change, and I agree, the latter is better!
    Last edited by Bob Phillips; 05-03-2022 at 08:46 AM. Reason: Removed unnecessary quoting

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •