I have the below pivot table. The stores are the "Market" and the employees are the "Name". The below code will find each market (store name), but how can I get the corresponding values in the "Total Hours" category?


    For Each objPivotItem In objPivotTable.PivotFields("Market").PivotItems
        name = objPivotItem.name
    Next
Row Labels	Total Hours
Easy Wireless Store 02	135.44
Counce,Kirby  	0
Curran,Markia  	0
Hernandez,Karen  	32.52
Hibler,Bullet  	0
Howard,Stephanie  	33.38
Marsh,Jeremy  	0
McCrary,Brandi Nicole	36.37
Schmidt,Joseph Robert	0
Tsoulogiannis,Nikolaos  	0
Tsoulogiannis,Vasilios  	0
Wool,Jeffery  	33.17
Easy Wireless Store 04	125.49
Brown,Marisca	26.45
Corley,Joshua John	39.92
Gonzalez,Melissa  	30.55
Maxon,Krystal M	0
Peoples,Deana L	28.57
Easy Wireless Store 05	94.36
DUNN,JAMES  	29.8
FRICANO,CRYSTAL  	34.88
Lollis,Sharda  	29.68
Easy Wireless Store 06	88.86
Gunnells,Dustin  	21.18
HARRIS,MICHAEL  	38.18
Henderson,Micah Rayn	29.5
Also is there a way to get the row,col location of a field or value when it is found?