Thread: copy sheets
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
scott scott is offline
external usenet poster
 
Posts: 577
Default copy sheets

Thanks for the quick response.

I closed all other files. The first line of the 'Move or copy' box did point
to the same file I am using. It just didn't work.

"Eduardo" wrote:

Hi,
check that when you chec the box create a copy , the first line where it
says To Book, has the name of the worksheet you are using, otherwise you are
creating a copy in another workbook

"Scott" wrote:

I clicked the tab of a sheet and then right clicked and chose 'Move or Copy'.
I checked the box of 'Create a copy' and clicked 'OK'. But nothing
happened.

The file has only 3 sheets total. Before, I accidently ran a macro to create
many sheets, but I deleted all of them with 3 sheets left.

I have never encountered such situation. This method has always worked
until today.

Thanks for help.