I have a acquired a workbook with many worksheets and I want to apply the
same name to the same cell on each worksheet.
To date, the only way I have managed this is to name the cell in the first
worksheet, then for each of the remaining sheets, move the sheet to a new
workbook, name the cell and then move the worksheet back into the original
workbook. Slow and laborious.

Anyone know of a quicker method?

Any suggestions gratefully received

Philip