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



<[email protected]> wrote in message
news:[email protected]...
> 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?
>