MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Return the worksheets name


Posted by Carl on January 28, 2001 8:43 PM

Is there a way to return the name of a worksheet with a formula into any given cell?
Either VB or in the worksheet.


Posted by Garland on January 28, 2001 9:19 PM

A simple VBA routine would be:

Sub sheetName()
Range("a1").Value = ActiveSheet.Name
End Sub

G.

Posted by Carl on January 28, 2001 9:24 PM

Thank you Garland ยง:^)