Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add data to the name of a tab
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add data to the name of a tab
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). -- Rick (MVP - Excel) "pgarcia" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Save 60% on Data Entry, Data Conversion, Data Processing Services byOffshore-Data-Entry | Excel Programming | |||
Save 60% on Data Entry, Data Conversion, Data Processing Services byOffshore-Data-Entry | Excel Programming | |||
Reliable Data Conversion,Data Formats and Data Entry Services by DataEntry India | Excel Programming | |||
Data Entry Online, Data Format, Data Conversion and Data EntryServices through Data Entry Outsourcing | Excel Discussion (Misc queries) | |||
Excel Macro for taking data external data and populating it on a sheet and deleting unwanted data | Excel Programming |