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?