title | keywords | f1_keywords | api_name | ms.assetid | ms.date | ms.localizationpriority | ||
---|---|---|---|---|---|---|---|---|
Worksheet.Name property (Excel) |
vbaxl10.chm174080 |
|
|
3d000cdf-5e81-8701-ca7f-bdcce006363b |
05/30/2019 |
medium |
Returns or sets a String value that represents the object name.
expression.Name
expression A variable that represents a Worksheet object.
The following code example sets the name of the active worksheet equal to today's date.
' This macro sets today's date as the name for the current sheet
Sub NameWorksheetByDate()
'Changing the sheet name to today's date
ActiveSheet.Name = Format(Now(), "dd-mm-yyyy")
'Changing the sheet name to a value from a cell
ActiveSheet.Name = ActiveSheet.Range("A1").value
End Sub
[!includeSupport and feedback]