1

Topic: Determination of row numbers and columns of the necessary cells from the pivot table

Hello!
There is a generated pivot table. From this pivot table it is necessary to pull out the different data from different cells.
For this purpose I wrote the code which defines coordinates of cells for different cases. It would be desirable, that estimated the code, whether not too difficult wrote, whether missed that how it would be possible to write on another, and also in certain cases found it difficult to write the code. In the code specified these moments.

2

Re: Determination of row numbers and columns of the necessary cells from the pivot table

ferzmikk;
And it is possible and is easier
The formula

' =... ("Mera4"; $B$6; "Client"; "101")

The code

MsgBox PT.GetPivotData ("Mera4", "Client", "Klient101").Value ' to Select a field "Mera4" at the Client-> Klient101

3

Re: Determination of row numbers and columns of the necessary cells from the pivot table

VSVLAD wrote:

ferzmikk;
And it is possible and is easier
The code

MsgBox PT.GetPivotData ("Mera4", "Client", "Klient101").Value ' to Select a field "Mera4" at the Client-> Klient101

As a candidate solution.
But here it is important to pull out not only values, and coordinates. Because then will be some charts are under construction and by means of coordinates in charts in a choice of the data the necessary data will be pulled out.