Replace a formula a name from set of worksheets

Hi Excel gurus,

I have a requirement where i have set of 50 worksheets in a folder and all the worksheets has a name which is wrongly spelt. We dont have exact row and column as name may present in any cell. Is there any way we can write a VBA code and replace with correct name in all 50 worksheets instead of doing it from each worksheet.

Thanks
Daya

If all sheets are in the same wbook try Ctrl+H - Click Options and select within " workbook" Then replace All after entering what to look for and what to replace with

Hi, thanks for the reply, but we actually have different xl files in that folder.