VBA Macro to change name of worksheet

[dinkss]

Hi all,

Is there any way of creating a macro that will create new worksheet inside of workbook with weeks numbering?

I have worksheet named WEEK-21, and want to have a macro that when used (I will assign macro button) will create a new worksheet with name WEEK-22 and so on. So after pressing assigned button I want to be able to create new worksheets with weeks numbering following the name of the first workbook, so WEEK-22, WEEK-23, WEEK-24 etc etc.

Any help will be greatly appreciated.

 

[offthelip]

Yes it is possible to do this , this is a completely different question so I suggest you post it as a new question

 

[dinkss]

Yes it is possible to do this , this is a completely different question so I suggest you post it as a new question

Will do it, thanks buddy