Thank No Sparks,
Both versions worked well.
Thank you very much.
I know I am pushing it a bit but can you also give me a bit of an inkling as to how to use a macro to change the Worksheet Tab name.
I have the need to change the range of Sheet Tab names (SJan16, Sfeb16------------ Sdec16) to the sheet Tab names to ( SJan17, SFeb17 ---------SDec17).
I need to have this happen either manually or automatically after the date has changed from the 30/6/"YY" to the 1st of July ( the beginning of the financial year) or when I choose to manually change the operative date.
As the programme will not be running continuously the Manual option would be the preferred choice.
I still need to save the information that is contained on each respective sheet and then to have the pertinent cells cleared of all data before the Renaming takes place.
Hopefully this will be my last request for quite some time I hope.
It is nice to have such a wealth of information available at such short notice, I thank you once again.