RobBroekhuis
Technical User
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
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