How to ignore non-weekdays

[tuph]

I came across this great bit of code which successfully changes tab names in the attached monthly workbook.

However, I want the finished workbook to contain only sheets for weekdays. If a cell in Worksheets!A = FALSE the macro leaves the worksheet name as "sheetn", moves to the next worksheet and does the same, then changes the name on the subsequent worksheet.

Can I make it skip over the FALSE rows in Worksheets!A so that all of the unchanged tabs are at the far end of my workbook? Ideally I would like to delete all remaining worksheets named "sheetn".

Please Login or Register  to view this content.

[Fotis1991]

Hello

Let's try this

Please Login or Register  to view this content.

[tuph]

It's magic! Well - almost.

Thanks very much for this code. I edited it so that the rename sub works on rows A2:A40 but it only renames up to row 23 - see attached test workbook. I can't see anything else in the code that might prevent it from renaming the other tabs.

Please Login or Register  to view this content.

[Fotis1991]

It's because you have only 22 Sheets in your workbook, so code finds only 22 sheets to rename !

Create 10 more sheets in your workbook and then run the code!

[oeldere]

@tuph

why not just only add the weekday(data) in the range (of your first sheet?

[tuph]

Aha! That worked. Thanks very much. This code will help me in all sorts of ways.

[tuph]

why not just only add the weekday(data) in the range (of your first sheet?

Thanks for the suggestion but I want to create a template which is quick and easy for others to use. Using this method all the user needs to do is change the date in cell B2 to update the rest of the month on the Names worksheet then run the macro. The workbook is then ready to use. The left over worksheets are out of the way at the far end of the workbook and the user can choose whether to delete or ignore them.

[tuph]

Aha! That worked. Thanks very much. This code will help me in all sorts of ways.

Now I'm really stumped oeldere! It worked until I saved the workbook as a macro enabled template. When I creaet a new workbook using the template the macro only works as far as row 30 in the Names worksheet. The uploader would not allow me to attach the template so I have attached a workbook created from the template.

[tuph]

Now I'm really stumped oeldere! It worked until I saved the workbook as a macro enabled template. When I creaet a new workbook using the template the macro only works as far as row 30 in the Names worksheet. The uploader would not allow me to attach the template so I have attached a workbook created from the template.

Actually I'm just stupid. The worksheet names have all been updated - they are simply sorted in text order rather than as dates. Is there any way around this?

This workbook is populated with a daily export of completed sales orders from our accounting system that allows us to back date invoicing on day 1 of the new month as the last day of the previous month. Logically, the first day of next month needs to follow the last day of this month in sequence.