Hi

Post the code you have created

--
Regards
Roger Govier

"skippy51" wrote in message
...
I want to create a pivot table using the pivot table wizzard from a
worksheet
into a worksheet with the name table by running a macro. when I record the
macro I create the pivot table using the wizzard and it works fine but
when I
try to run the macro again it errors "unable to get the pivot tables
property
of the worksheet class" any help?