naming tabs based on cell

[jammoca]

What I'm looking for is a code that will name a Sheet Tab whatever is in cell A8 of that same sheet.

I don't want all sheets in the workbook named this way only a few.

The name that appears in cell A8 is the result of a formula ( it hasn't been typed in ) i don't know if that makes any difference to the code needed

I've read numerous reviews of this topic and am trying to use the followng code ..

Sub NameSheets()
Dim ws As Worksheet
For Each ws In ActiveWorkbook.Worksheets
ws.Name = ws.Range("a1")
Next ws
End Sub

however it doesn't seem to be doing anything and I suspect it's trying to name all sheets in the workbook .. I don't want that.

Can you please be specific as to where I need to paste the code, eg: is it in Module for that sheet or Class Module etc etc etc you can see I'm a newbie to VBA

sorry

 

[venkat1926]

yes your macro names ALL the sheets for A1 value in that sheet.
the macro is parked in vb editor

hit alt+F11.and control+R and choose the name of that particuar workbook click aat the top insert=-module . a module window will open and park your macro there.
and then you have to run that macro.

If you want only a few of the sheets named as the cell value at that sheet you have to tell which are these sheets. If it is one or two you manually do it. otherwise clarify which sheets are t o be renamed. There should be some logic in the sheets chosen e.g. first three sheets, last three sheets, three sheets after a particular sheet etc.