If you want to know what sheet the pivot on the active sheet is on you coulduseActiveSheet.NameBut I suspect your question is meant to be more complicated than that.