Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Renaming tabs
I am running monthly financials in FRX and creating worksheets into excel.
The starting names are different for each property but the tabs need to have the same names. Is there anyway to write a macro by placement of tab to name the tabs in each separate worksheet over and over again each month? There are 7 tabs in the final worksheet. Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Renaming tabs
There would logically need to be some difference in the Sheet (Tab) name to
avoid confusion in formulas and code. But you could, once you file transfer is completed run a short macro to name the sheets. Set wb = Workbooks("Somename.xlx?") 'Use actual Name and extension. For i = 1 To wb.Sheets.Count wb.Sheets(i).Name = "Samename" & i 'Use actual sheet name. Next This would be the same name except that it would number the sheets consecutively. "MSPKELLEY" wrote in message ... I am running monthly financials in FRX and creating worksheets into excel. The starting names are different for each property but the tabs need to have the same names. Is there anyway to write a macro by placement of tab to name the tabs in each separate worksheet over and over again each month? There are 7 tabs in the final worksheet. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Renaming Tabs | Excel Discussion (Misc queries) | |||
renaming worksheet tabs | Excel Discussion (Misc queries) | |||
Renaming Tabs | Excel Discussion (Misc queries) | |||
Renaming tabs | Excel Programming | |||
Renaming worksheet tabs | Excel Programming |