Can't expand named range. (Error 3434)

Cells with values were encountered while attempting to add rows to a Microsoft Excel version 5.0 named range. These cells cannot be overwritten by an append operation.