Opening a new tab

  • Thread starter Thread starter Ed Davis
  • Start date Start date
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.
 
You did mean to say ADD a sheet, didn't you.

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