Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel new chart sheet index

Status
Not open for further replies.

RobBroekhuis

Technical User
Oct 15, 2001
1,971
US
I'm trying to add a new chart sheet, using the statement

Charts.Add after:=Sheets(Sheets.Count)

I want the new chart to appear as the last tab in the sheet tab order. Instead, it comes out second-to-last. Some debugging on the immediate screen yields:

Before execution of the command above:

?sheets.Count
?sheets(sheets.Count).name
info

After execution of the command above:

?activesheet.index
5
?sheets("info").index
6

What's going on?
Rob
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top