Right now I am using the following VBA Code:
Sub tabname()
Dim ws As Worksheet
For Each ws In Worksheets
ws.Activate
ws.Name = Range("$D$5").Value
Next
End Sub
But I keep getting 1004 application-oriented or object-oriented error. Please help
Bookmarks