Re: $$Excel-Macros$$ Re: Macro to create Pivot Table for each sheet in the workbook

2012-10-16 Thread prkhan56
Dear Ashish, I was out of town so could not reply earlier I found the mistake and now it is working fine. super thanks a lot Rashid On Sunday, October 14, 2012 1:24:38 PM UTC+4, ashish wrote: Hi Its working fine on my desktop. Can you send the file Also specify which version of

Re: $$Excel-Macros$$ Re: Macro to create Pivot Table for each sheet in the workbook

2012-10-14 Thread koul . ashish
Hi Its working fine on my desktop. Can you send the file Also specify which version of office u r using Sent on my BlackBerry® from Vodafone -Original Message- From: prkhan56 prkha...@gmail.com Sender: excel-macros@googlegroups.com Date: Sat, 13 Oct 2012 12:01:09 To:

Re: $$Excel-Macros$$ Re: Macro to create Pivot Table for each sheet in the workbook

2012-10-13 Thread prkhan56
Dear Ashish, I am still waiting some guidance from your end Regards Rashid khan On Tuesday, October 9, 2012 11:08:19 PM UTC+4, prkhan56 wrote: Hello Ashish, Any guidance to solve the problem I am facing? Thanks Rashid Khan On Sunday, October 7, 2012 8:59:04 PM UTC+4, prkhan56 wrote:

Re: $$Excel-Macros$$ Re: Macro to create Pivot Table for each sheet in the workbook

2012-10-09 Thread prkhan56
Hello Ashish, Any guidance to solve the problem I am facing? Thanks Rashid Khan On Sunday, October 7, 2012 8:59:04 PM UTC+4, prkhan56 wrote: Hello Ashish, When I run call_pivot It gives Run-time Error '9' Subscript out of range and highlights the following line: Call

Re: $$Excel-Macros$$ Re: Macro to create Pivot Table for each sheet in the workbook

2012-10-07 Thread prkhan56
Hello Ashish, When I run call_pivot It gives Run-time Error '9' Subscript out of range and highlights the following line: Call create_pivot_table(Sheets(Sheets(List).Range(a i).Value)) Am I doing something wrong? Thanks for your time once again. Rashid On Sunday, October 7, 2012 9:56:27 AM

$$Excel-Macros$$ Re: Macro to create Pivot Table for each sheet in the workbook

2012-10-06 Thread prkhan56
On Monday, October 1, 2012 9:11:00 PM UTC+4, prkhan56 wrote: I posted this yesterday...it seems it did not get through..so posting once again Hello All, I am using Excel 2010. I have a List of Names in Sheet name “List” I have attached a file with two modules. *Module1* Macro

Re: $$Excel-Macros$$ Re: Macro to create Pivot Table for each sheet in the workbook

2012-10-06 Thread ashish koul
run a loop and pass sheet names to sub routine create_pivot_table Sub call_pivot() Call create_pivot_table(Sheets(Participant1)) End Sub Sub create_pivot_table(wk As Worksheet) Application.DisplayAlerts = False Dim pt As PivotTable Dim PTCache As PivotCache Dim wks As

Re: $$Excel-Macros$$ Re: Macro to create Pivot Table for each sheet in the workbook

2012-10-06 Thread prkhan56
Hello Ashish, Thanks for the code. Do I have to do the looping as follows: Sub call_pivot() Call create_pivot_table(Sheets(Participant1)) Call create_pivot_table(Sheets(Participant2)) Call create_pivot_table(Sheets(Participant3)) Call create_pivot_table(Sheets(Participant4)) Call

Re: $$Excel-Macros$$ Re: Macro to create Pivot Table for each sheet in the workbook

2012-10-06 Thread ashish koul
try this Sub call_pivot() Dim i As Long For i = 2 To Sheets(List).Range(a65356).End(xlUp).Row Call create_pivot_table(Sheets(Sheets(List).Range(a i).Value)) Next End Sub Sub create_pivot_table(wk As Worksheet) Application.DisplayAlerts = False Dim pt As PivotTable Dim PTCache As

$$Excel-Macros$$ Re: Macro to create Pivot Table for each sheet in the workbook

2012-10-04 Thread prkhan56
Hello Ashsh, I posted my query and dont see it Did it get through. Rashid On Monday, October 1, 2012 9:11:00 PM UTC+4, prkhan56 wrote: I posted this yesterday...it seems it did not get through..so posting once again Hello All, I am using Excel 2010. I have a List of Names in Sheet name