HI Raj,
You can use the below mention code:
Focus on arguments and understand them, it's easy, you'll never
forget.
ThisWorkbook.PivotCaches.Create(SourceType:=xlDatabase, _
SourceData:="Sheet2!R2C2:R6C6", _
Version:=xlPivotTableVersion12).CreatePivotTable _
TableDestination:="Sheet2!R12C2", _
TableName:="PivotTable1", _
DefaultVersion:=xlPivotTableVersion12
i Provide Source Data
ii Provide Pivot Table version - 12 is for Excel 2007 and 11 is for
Excel 2003.
iii Provide Pivot Table Destination
iv Provide Table Name for future operations and reference
These all are the compulsory options.
Try the code and let us know, if further help required.
________________________________________
Thanks & Regards
Ashish Jain
(Microsoft Certified Application Specialist)
(Microsoft Certified Professional)
http://www.excelitems.com
http://www.openexcel.com
________________________________________
On Nov 24, 2:12 pm, Raj Mahapatra <rajafs...@gmail.com> wrote:
> hi Group,
>
> Can any one send me the macro commands to create pivot table in excel.
>
> Thanks & Regards
>
> Rajesh
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
