View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Add data to the name of a tab

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

--
Gary''s Student - gsnu200832


"pgarcia" wrote:

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