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 §:^)
