Runtime error 1004 - when I increase the amount of data

  • Thread starter Thread starter Rachel Curran
  • Start date Start date
R

Rachel Curran

Hi,

I have a huge vba macro and it works fine, however when I increase the
amount of rows in the raw spreadsheet (the macro works from this) I
get a runtime error 1004. The macro works fine on rows upto and
including 997, however anything above this amount causes the runtime
error - unfortunately I cannot post all the code because there is far
too much. The code that the debug highlights on error is:

inputworkbook.worksheets(sheetname).range(rangestr).copy

Any ideas?
 
do you have merged cells included when you get above 997.

In any event, you can copy all the cells on the sheet with the copy command,
so there is no built in limitation for 997 rows. It must be something to do
with you particular sheet.
 
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

Runtime error 1004 when trying to insert formula in cells 11
Runtime error 1004 3
runtime error code 1004 2
debug runtime error 1004 2
RUNTIME ERROR 1004 2
Copy/Paste Problem: Runtime error 1004 5
"Run-time error '1004' 5
runtime error 1004 1

Back
Top