I have recorded a macro which creates a pivot table, when the macro runs
there is a run time error, at in the in VBA code whic is as follows :

ActiveSheet.PivotTables("PivotTable3").AddFields RowFields:=Array( _
"Payment Type 2", "Data")

Ant help appreciated.

Thanks

--
Message posted via http://www.officekb.com

Hi Nicki

What error do you get?
It may be that PivotTable3 already exists.

--
Regards
Roger Govier

"nickd via OfficeKB.com" <u35935@uwe wrote in message
news:86f435902a5e9@uwe...
I have recorded a macro which creates a pivot table, when the macro runs
there is a run time error, at in the in VBA code whic is as follows :

ActiveSheet.PivotTables("PivotTable3").AddFields RowFields:=Array( _
"Payment Type 2", "Data")

Ant help appreciated.

Thanks

--
Message posted via http://www.officekb.com

Thanks for having a look error is as follows :
run-time error '1004'
AddField method of pivot table class falied


Question 2

I have several worksheets in a workbook, and I would like to retrieve in one
worksheet all accounts with detials that begin with a 4, or an account number
which has 8 numeric characters which are included in the the several work
sheets.

I am a novice on excel but need to learn very quickly, if you have an example
that would be very helpful.

Thanks for your time

Roger Govier wrote:
Hi Nicki

What error do you get?
It may be that PivotTable3 already exists.

I have recorded a macro which creates a pivot table, when the macro runs
there is a run time error, at in the in VBA code whic is as follows :
[quoted text clipped - 5 lines]

Thanks

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200807/1

Hi Nicki

I can't quite understand what it is that you want.
If you want, you can email me the file direct, with some more detail on what
you are trying to achieve.

To send direct email to
roger at technology4u dot co dot uk
Change the at and dots to make valid email address.

--
Regards
Roger Govier

"nickd via OfficeKB.com" <u35935@uwe wrote in message
news:872e413513e95@uwe...
Thanks for having a look error is as follows :
run-time error '1004'
AddField method of pivot table class falied


Question 2

I have several worksheets in a workbook, and I would like to retrieve in
one
worksheet all accounts with detials that begin with a 4, or an account
number
which has 8 numeric characters which are included in the the several work
sheets.

I am a novice on excel but need to learn very quickly, if you have an
example
that would be very helpful.

Thanks for your time

Roger Govier wrote:
Hi Nicki

What error do you get?
It may be that PivotTable3 already exists.

I have recorded a macro which creates a pivot table, when the macro runs
there is a run time error, at in the in VBA code whic is as follows :
[quoted text clipped - 5 lines]

Thanks

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200807/1