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.

--
Regards,
Tom Ogilvy

"Rachel Curran" wrote in message
om...
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?