Use the sheet index, not the sheet name.

So refer to the sheet as..... Sheets(1)


--

Regards,
Nigel




"Vijay Kotian" wrote in message
...
I am getting a file wherein the name of the worksheet is not unique and i
am
finding it dffficult to rename through program.

Can anyone help me out to rename a worksheet which is named differently
every time and normally only one worksheet is found in workbook.

Thank you in advance