Hi All,
I have a workbook that has around 100 sheets each with a different name and I need to add the month each sheet name so basically it will be 'current sheet name - Month' the month will obviously change each time and so I don't mind having to change the macro to tell it what to put in...