I have a workbook consisting of a chart sheet (created by F11 key) ("Chart1") and then followed by Sheet1 that has its data.
When on Sheet1, ActiveSheet.Index = 2 and Worksheets.Count = 1
ActiveSheet.Index exceeds Worksheets.Count !
ARRGH! Whose .Count is 2? And/or whose .Index is 1 for Sheet1? Is there a simple guide applicable here for the difference between Sheet and Worksheet, or Sheets and Worksheets?