Worksheet name

P

Patol

Hi! can anyone tell me how to make the worksheet tab name equals to a
certain cell content, please?
Thanks!
 
M

Mark

Try this:

Sub AutoNameSheet()

Application.ActiveSheet.Name = Application.ActiveCell

End Sub

just select the cell that has the name you want your sheet to have and
then run this macro.
 
M

Mark

Try this:

Sub AutoNameSheet()

Application.ActiveSheet.Name = Application.ActiveCell

End Sub

just select the cell that has the name you want your sheet to have and
then run this macro.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Coding Help for Beginner 0
AppleScript - How do I select a text ? 1
Consolidation Table from Different Excel Tabs with Different Format 1
To make pdf to work as word 1
Visio: copy text of a master shape to User-define Cells (Variable) 0
Crating User Form to Add Names 1
Word 2013 field code Nested IF statement 1
How to clear areas of a locked Doc after each use-- 0

Top