Add data to the name of a tab

  • Thread starter Thread starter pgarcia
  • Start date Start date
P

pgarcia

Hello all,
I need to add " - Pening" to the name of my tabs each month. Is there a maco
that can do this for me?

Thanks
 
Sub pening()
For Each s In Sheets
s.Name = s.Name & " - Pening"
Next
End Sub
 
Every tab? If so, then Gary''s Student's macro should do what you want.
However, if your question is trying to imply that your tabs are monthly in
some way and that you want the one for the current month (or that one and
all months after it) to be changed, then you will have to describe your
setup in more detail (specifically, how your tabs are currently named).
 
Back
Top