ferocious12
Member
Hi Guys,
I am using the following macro to rename worksheets in the file (this is part of number of macros I am using). It does the job and rename all the worksheets but code stops and goes into debug mode. What may be wrong?
Thanks
I am using the following macro to rename worksheets in the file (this is part of number of macros I am using). It does the job and rename all the worksheets but code stops and goes into debug mode. What may be wrong?
Code:
Sub RenamWs()
Dim WS As Worksheet
For Each WS In Sheets
WS.Name = WS.Range("A7")
Next WS
End Sub