Getting started with excel-vbaDebugging and TroubleshootingMethods for Finding the Last Used Row or Column in a WorksheetUser Defined Functions (UDFs)VBA Best PracticesLoop through all Sheets in Active WorkbookRanges and CellsCommon MistakesArraysExcel VBA Tips and TricksPowerPoint Integration Through VBAWorkbooksPivot TablesBindingCharts and ChartingApplication objectMerged Cells / RangesVBA SecurityHow to record a MacroLocating duplicate values in a rangeNamed Rangesautofilter ; Uses and best practicesCreating a drop-down menu in the Active Worksheet with a Combo BoxConditional statementsWorking with Excel Tables in VBAExcel-VBA OptimizationConditional formatting using VBAFile System ObjectSQL in Excel VBA - Best PracticesUse Worksheet object and not Sheet objectCustomDocumentProperties in practice
Use Worksheet object and not Sheet object
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
Contributors
Topic Id: 9996
Example Ids: 30699
This site is not affiliated with any of the contributors.