Re: $$Excel-Macros$$ Need named range or named range book Pivot Table

Hi, Please share the sample file with the Group along with the expected result. I could make out that you would like to use Named Ranges with Pivots Best Regards, DILIPandey On 2/25/11, ChilExcel chilexcel...@gmail.com wrote: Hi macro I need to double click PivotTable I need to get sheet

$$Excel-Macros$$ Need named range or named range book Pivot Table

Hi macro I need to double click PivotTable I need to get sheet named range or named range book something very similar to drilldown but named range in sheet or book contribution If someone needs to shoot macro drill down on a sheet of Pivot table, or on another sheet I send a file --