You receive a "Runtime error 1004" error message when you try to copy and to paste filtered data pro

This issue may occur if either of the following conditions is true: 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

support.microsoft.com