Add data to the name of a tab

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
 
G

Gary''s Student

Sub pening()
For Each s In Sheets
s.Name = s.Name & " - Pening"
Next
End Sub
 
R

Rick Rothstein

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).
 
Top