alistair23
New Member
- Joined
- Dec 19, 2021
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Hi all! I'm trying to rename all the worksheets in a workbook so the sheet name is = to contents of cell B3.
*Cell B3 contains a full name, _ and kanji characters (example: Chris Stevens_城田陸)
I tried using the below VBA but I get an error 'run time error 13' type mismatch...not sure how to fix this
Could someone help correcting this for me?
Thank you so much in advance!
Tried VBA:
Sub sample()
Dim sh As Worksheet
For Each sh In Worksheets
With sh
.Name = .Range("B3").Value
End With
Next sh
End Sub
*Cell B3 contains a full name, _ and kanji characters (example: Chris Stevens_城田陸)
I tried using the below VBA but I get an error 'run time error 13' type mismatch...not sure how to fix this
Could someone help correcting this for me?
Thank you so much in advance!
Tried VBA:
Sub sample()
Dim sh As Worksheet
For Each sh In Worksheets
With sh
.Name = .Range("B3").Value
End With
Next sh
End Sub