Remember you can record macros by going to Tools, Macro, Record Macro..
Do so, and then Go through the PT Wizard (steps 1-4?). When Complete Stop
Macro.

View your Code in the VBE (Alt+F11).

HTH


"ssathis_1982: TRICHY - S.INDIA" wrote:

Dear Sir,

During the Macro execution mode, I can't able to get the pivot table. So, Is
it possible to make the Pivot table with the help of Macro.

Regards,
S.Sathiskumar,
S.India.