Show a tab with a graph

hi,

I know that to show a tab in VBA you can write
worksheet("NameOfTheTab").select
However, it does not work when the tab is just graph

Hope that makes sense

Any idea???

Many thanks

Pierre

Originally Posted by pilou

hi,

I know that to show a tab in VBA you can write
worksheet("NameOfTheTab").select
However, it does not work when the tab is just graph

Hope that makes sense

Any idea???

Many thanks

Pierre

Hi Pierre

That's because it's not a worksheet. It's a Chart sheet.

You can use

Charts("NameOfTheTab").Select

or use the Sheets collection, that has all types of sheets:

Sheets("NameOfTheTab").Select

HTH

thanks a lot
it works great

thanks again