Tabs Names
in [Functions]
|
From: MDI Anne on 30 Mar 2010 14:18 Is it possible to change all of the tabs names in my workbook (using something similar to "find & replace"?? ex: workbook tabs names: Q107, Q207, Q307, Q407 (for quarterly reports in 2007) Now I want to change the tabs to read: Q108, Q208, Q308, Q408. Is there a quick way? Thanks!
From: Jim Thomlinson on 30 Mar 2010 14:20 Nope. Not without resorting to a macro. Depending on how many sheets it may be quicker to just do it by hand than to write a macro. -- HTH... Jim Thomlinson "MDI Anne" wrote: > Is it possible to change all of the tabs names in my workbook (using > something similar to "find & replace"?? > > ex: workbook tabs names: > > Q107, Q207, Q307, Q407 (for quarterly reports in 2007) > > Now I want to change the tabs to read: > > Q108, Q208, Q308, Q408. > > Is there a quick way? > > Thanks!
From: Eduardo on 30 Mar 2010 14:33 Hi, Dave P has provide to the community the macro as follow Maybe something like: Option Explicit Sub testme() Dim iRow as long with activesheet for irow = 1 to .cells(.rows.count,"A").end(xlup).row sheets(irow).name = .cells(irow,"A").value next irow end with End with This could fail if you have invalid names in column A and/or there are duplicate names or sheets with the same name already existing. Or if you don't have enough sheets! "MDI Anne" wrote: > Is it possible to change all of the tabs names in my workbook (using > something similar to "find & replace"?? > > ex: workbook tabs names: > > Q107, Q207, Q307, Q407 (for quarterly reports in 2007) > > Now I want to change the tabs to read: > > Q108, Q208, Q308, Q408. > > Is there a quick way? > > Thanks!
From: MDI Anne on 30 Mar 2010 14:50 Okie dokie... that's what I thought, but just wanted to check. Thanks!! "Jim Thomlinson" wrote: > Nope. Not without resorting to a macro. Depending on how many sheets it may > be quicker to just do it by hand than to write a macro. > -- > HTH... > > Jim Thomlinson > > > "MDI Anne" wrote: > > > Is it possible to change all of the tabs names in my workbook (using > > something similar to "find & replace"?? > > > > ex: workbook tabs names: > > > > Q107, Q207, Q307, Q407 (for quarterly reports in 2007) > > > > Now I want to change the tabs to read: > > > > Q108, Q208, Q308, Q408. > > > > Is there a quick way? > > > > Thanks!
|
Pages: 1 Prev: GETPIVOTDATE Funtion Next: Countif function to show how often numbers within a range are |