ExcelBanter - Using VBE to change tab name

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Using VBE to change tab name (https://www.excelbanter.com/excel-programming/362084-using-vbe-change-tab-name.html)

joeski

Using VBE to change tab name

Hi

How do I change the tab name for a worksheet in VBE?
--
joeski

Tom Ogilvy

Using VBE to change tab name

worksheets("Sheet1").Name = "Smurf"

--
Regards,
Tom Ogilvy

"joeski" wrote:

Hi

How do I change the tab name for a worksheet in VBE?
--
joeski

Norman Jones

Using VBE to change tab name

Hi Joeski,

Try:

'=============
Public Sub Tester004()
Sheets("Sheet1").Name = "MySheet"
End Sub
'<<=============

---
Regards,
Norman

"joeski" wrote in message
...
Hi

How do I change the tab name for a worksheet in VBE?
--
joeski

All times are GMT +1. The time now is 03:30 PM.