Naming Sheets in Visual Basic

[lj]

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?

 

[Norman Jones]

Hi LJ,

Try:

ActiveSheet.Name = "YourChosenName"