I'm using VB and I have am in an unnamed sheet that was created when i
selected to show detail in a pivot table. My question is - Is there a
way to name the new sheet, which i am in, with out specifying what the
current name is?