problem with copying worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I have an Excel file with several worksheets, containing about 170 named cells, some buttons, some drop-downs. I have a macro, that makes copies of one sheet into the same workbook

For n = 1 To kilp Step
Sheets("hkt").Selec
ActiveSheet.Copy Workbooks(failinimi).Sheets(1
Nex

Lately I have begun to receive error messages while copying: "Copy method of worksheet class failed". First the error appeared when attempted to make 40th copy. Now I have added some data to the file and the limit has decreased to 35. I also tried to make copies of other sheets in the workbook and got same error messages, but in different "n" values, depending which sheet I chose to copy.
Does Excel have some limit how many named cells etc there can be in total or something
What could cause this error

BR
taavo
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Move or Copy Stopped Working? 0
Copying cells and formula from closed workbook to all sheets in open workbook 0
Copying a sheet fails 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
help with weird select-cell-copy-from-previous-worksheet function 1
Unhide sheet, copy and rename new sheets from list, rehide sheet 8
Copy Dynamic Range problem 2
Copy cell value from one worksheet to matching worksheet in another workbook 4

Back
Top