"Not responding".. when Sheets("xx1").Select

Hello,
I have a very annoying issue.

when executing the following code, the application hangs when simply trying to do a Sheets().Select.... it works on 2k2, 2k3,.. even 2k10, but not on 2k7 !

do you have any idea (security, code, etc..) ?? thanks

Please Login or Register  to view this content.

Thanks, but I have this error now :

Run-time error '1004'
Cannot rename a sheet to the same name as another sheet, a referenced object library or a workbook referenced by Visual Basic..



But can you see any reason it works only not on 2k7 ?

Originally Posted by arancia

Thanks, but I have this error now :

Run-time error '1004'
Cannot rename a sheet to the same name as another sheet, a referenced object library or a workbook referenced by Visual Basic..



But can you see any reason it works only not on 2k7 ?

You cannot keep same name for two worksheets. Please ensure that the name which you are trying to assign doesn't already exist in the workbook.

Also check if there is any hidden file.

Thanks,
Vikas

Ok, the [Sheets("xx1").Select] bug might be coming because the sheet may not exist in the workbook. Please find below a code snippet which I would have used for the similar purpose. Personally, I never prefer to select a cell or any other object(like chart) because it slows down the execution so I use it like the following way :

Please Login or Register  to view this content.