Note This issue does not occur when the data is not filtered.
- The Microsoft Visual Basic for Applications (VBA) macro copies and pastes one whole row in an Excel 2003 workbook.
- The Microsoft VBA macro copies and pastes a range of 2,516 rows or more rows in an Excel 2003 workbook.
To work around this issue if your VBA macro copies and pastes a single whole row, change the VBA macro code to copy only the section of the row that contains data. For example, use VBA macro code that is similar to the following code:
Range(Range("A" & ActiveCell.Row), Range("IV" & ActiveCell.Row).End(xlToLeft)).Select