Hi All,
I have the Cells(Row, Column) value, which I need to use to show the details of this cell value in a specific pivot table.
As far as I could see the most common usage is Range and then selection.showdetails = true.
I tried using the blow unsuccessfully:
Cells(FindRow.Row...
I have been trying to find a way to get my Pivot Table drilldown to occur on the same worksheet that the table is housed on. I have found a couple of posts by User Tom Urtis on here that relate for exactly what I am trying to do, but I am not sure where to start. I have been using excel for...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.