Find specific word in cell A1 in worksheets
Posted on 2014-03-18
I have a workbook with several worksheets which when saved down are saved with different names each time. [please don't ask why :-)]
I need to find the word Summary which is in cell A1 in one of the worksheet and then rename the worksheet to Summary
Could an expert provide me with the VBA code to do this please.