Re: Assign a macro to create a pivot table
- From: "Tom Ogilvy" <twogilvy@xxxxxxx>
- Date: Wed, 22 Jun 2005 08:11:33 -0400
I suspect the problem lies in a disconnect in your code and your data. The
sample code follows the proper syntax for the function. It is possible that
the condition of the table at the time the code is run does not permit this
modification. Only you can tell that by working through your code a step at
a time and examining the situation.
--
Regards,
Tom Ogilvy
"acsugguiyao" <acsugguiyao.1r0yig_1119438319.5689@xxxxxxxxxxxxxxxxxxxxx>
wrote in message
news:acsugguiyao.1r0yig_1119438319.5689@xxxxxxxxxxxxxxxxxxxxxxxx
>
> I am currently creating a macro from a data worksheet but I am receiving
> an error.
> :(
>
> Initially, I just recorded the macro however when I am running it, i am
> receiving an addfields method of Pivot Table Class failed.
>
> ActiveSheet.PivotTables("PivotTable4").AddFields RowFields:="Level 3",
> _
> ColumnFields:="Date"
>
> this is code that was having an error and I am not sure what was wrong
> with it?
> Can someone forward me a sample of the macro code to resolve this?
>
> Alib
>
>
> --
> acsugguiyao
> ------------------------------------------------------------------------
> acsugguiyao's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=24519
> View this thread: http://www.excelforum.com/showthread.php?threadid=381168
>
.
- Follow-Ups:
- Re: Assign a macro to create a pivot table
- From: acsugguiyao
- Re: Assign a macro to create a pivot table
- References:
- Assign a macro to create a pivot table
- From: acsugguiyao
- Assign a macro to create a pivot table
- Prev by Date: Re: Searching 1 column for data
- Next by Date: Re: Cutcopymode problem
- Previous by thread: Assign a macro to create a pivot table
- Next by thread: Re: Assign a macro to create a pivot table
- Index(es):
Relevant Pages
|
