I thought I had this working but apparently not. I have 100+ worksheets in
my workbook, I need a macro which when run will rename each worksheet to the
worksheets cell AB1 (each worksheet will have its own cell AB1 which will
contain the text to be used as the worksheets name) and when it is done it
must return me to the worksheet which was active when called the macro.