Search:

Type: Posts; User: kavster; Keyword(s):

Search: Search took 0.00 seconds.

  1. Re: Runtime error 5, Invalid Procedure call or argument error when creating a pivot table

    Managed to fix the issue. The solution needed me to apply the following:



    Sub CreatePivot()

    Sheets("Data").Activate
    Sheets("Data").Range("B7").Select
    Range(Selection,...
  2. Re: Runtime error 5, Invalid Procedure call or argument error when creating a pivot table

    Apologies, here it is:


    Sub CreatePivot()

    Sheets("Data").Activate
    Sheets("Data").Range("B7").Select
    Range(Selection, Selection.End(xlToRight)).Select
    Range(Selection,...
  3. Re: Runtime error 5, Invalid Procedure call or argument error when creating a pivot table

    Hi Rory,

    I apologise for posting in the same thread about my problem but I am receiving an identical error to VBAProIWish's. However, my sheet is simply called "Pivot" with no special characters....
  4. Replies
    5
    Views
    2,286

    Re: VBA To remove filters from Pivot tables

    Great! Thanks for your prompt reply.
  5. Replies
    5
    Views
    2,286

    Re: VBA To remove filters from Pivot tables

    Could you please post your solution up here? I'm having a similar issue.

    Cheers.
Results 1 to 5 of 5