LinkBack URL
About LinkBacks
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
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
Hi, brandnew22,
1004 is the "best" documented error.Maybe doubled up name, illegal characters used...
Maybe use
Ciao,
Please Login or Register to view this content.
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks