Renaming multiple worksheets from cell reference

[dozen_redroses]

Hi

I am completely new to this - my first forum post ever, so please excuse me if I have written this in the wrong place, or the answer is already in here somewhere. I have done a bit of searching, and thought that I had got the answer I needed, but just can't get it to work, so thought that I would give my exact problem.

I have created timesheets in excel with each fortnight on a different worksheet. The dates are listed in column B, with the first day of the pay period being in B13 and the last in B28. I would like the name of each worksheet to show those two dates with a - separating them. Example below. My research has suggested that I need to do this through VBA. I have tried copying posts from other people and changing the cell reference, but just can't get it to work!

Any help would be greatly appreciated.

Thanks

[JoeFoot]

try this:

Please Login or Register  to view this content.

you must run the code on sheet of interest and it will rename that sheet with the content of the cells you specified.

[dozen_redroses]

Thank you so much JoeFoot, that has worked!

Just wondering though... is there a way that I can update all of the tabs in one go? I have 11 workbooks with 26 worksheets in each...

Thanks

[JoeFoot]

sure

do this:

Please Login or Register  to view this content.

this will name all your sheets in the current book in accordance to the values of the cells populating those sheets