Naming Sheets in Visual Basic

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?

Hi LJ,

Try:

ActiveSheet.Name = "YourChosenName"

---
Regards,
Norman



<lj@spu.edu> wrote in message
news:1119044016.117932.220970@z14g2000cwz.googlegroups.com...
> 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?
>