TabSheet Name vs Cell Value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I thought I saw a similar post a few days back, but I can't seem to locate it
....

Above said ... Is it possible to have a TabSheet Name based on a Cell Value
.... ie: If a Part # is in a specific cell can it somehow be used to name the
TabSheet? ... Thanks ... Kha
 
Just make sure that the Value you need the sheet named resides in either A11,
or edit this macro

Sub SameNameTab()
Dim i As Integer
On Error Resume Next
For i = 1 To Sheets.Count
Sheets(i).Name = Sheets(i).Range("a11").Value
Next i
 
Oversight on my part ... If there are TabSheets that I do not want impacted
by this Macro (mostly likely my master data sheet TabSheet1 & possibly
TabSheet2) ... how do I prevent this?

Thanks ... Kha
 

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

Cell Value vs TabSheet Name 7
Return mm/dd/yy based on 1st Day of Month 5
Macro for Filter Switches ... Maybe??? 4
user defined name for function with relative reference to tabsheet 3
SUMPRODUCT vs Text??? 2
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Index/Match vs VLookup? 4
ListBox (maybe?) ... If so, how? 3

Back
Top