Recent content by cagirish81

Dear All, Thnx for suggestions.. @ Narayan the code is perfectly working after reducing the formula length to 255 characters. Many thanx for your help. @ Debraj Roy While calculating value of C "May-12" should be in date format ie MMM/YY. Regret for not mentioning that. Secondly, in...

Sincere apology for inconvenice.. Forgot to mention one line of vba code in below post C = Application.WorksheetFunction.CountIfs(Sheets("Sheet2").Range("A:A"), "Auto", Sheets("Sheet2").Range("B:B"), "May-12")

Hi, I want to define an array formula for range of cells in excel 2007 vba. I am using following vba code but getting error : Unable to set the FormulaArray property of the range class. Plz help.. Sub ArryForm () Dim IncFormula As String IncFormula = "=IFERROR(-INDEX('Data Summary...

Hi Luke, Sincere apology for inconvenience. I realised my mistake. In base data, page filter value ie date was in MMM/YY format whereas in macro the format is DD/MM/YYYY. I have changed the format in base data and now its working perfectly. Thanks a lot.

Hi Luke, Thanks for your reply. Yes I want to create new PT thru vba. Everything goes fine without setting page field and after adding rows & columns fields. I recorded the above macro to create new PT and set page field (This is the exact macro recorded by excel 2007). But, when I run the...

Hi All, Good Evening.. This is Girish from Mumbai, joined this worderful site few days back.. I have just started learning macros and vba.. Can anyone help me for following error? I am creating pivot table in excel 2007 using vba. I want to set page field for pivot table. since I am a...