Use Worksheet object and not Sheet object - Excel VBA Full Tutorial

Excel VBA - Use Worksheet object and not Sheet object

Start

Start
Print the name of the first object (opens new window) `Option Explicit Sub CheckWorksheetsDiagram() Debug.Print Worksheets(1).Name Debug.Print Charts(1).Name Debug.Print Sheets(1).Name End Sub` The result: `Sheet1 Chart1 Chart1`

Print the name of the first object

Option Explicit

Sub CheckWorksheetsDiagram()

    Debug.Print Worksheets(1).Name
    Debug.Print Charts(1).Name
    Debug.Print Sheets(1).Name

End Sub

The result:

Sheet1
Chart1
Chart1

Read Article
https://develop.horje.com/learn/1434/reference