Opening a new tab

E

Ed Davis

I would like to open a new tab with the name that is in a cell.
Example in Cell b10 I have a number in this case it is 13245 and would like
to open a new tab with that number 13245.
The number will change many times.
I would like to do this in a macro.
 
D

Don Guillett

You did mean to say ADD a sheet, didn't you.

Sub addsheetandname()
Sheets.Add.Name = Range("b10")
End Sub
 

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

Opening a new tab 2
Adding a comment in a footnote area 1
Paragraph numbering in Word 1
Section and Page numbering 0
Drop down list control value in vba 2
Row Deletion Question 2
Word- Find and Replace 1
Consolidation Table from Different Excel Tabs with Different Format 1

Top