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! |
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! |
All times are GMT +1. The time now is 11:47 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com