Could it be that your data range includes some not yet used cells?
Perhaps use a dynamic range instead which will adapt to the added data (using Insert Table perhaps)
See https://www.contextures.com/xlNames01.html#Dynamic for suggestions


If need be post a sample sheet with some ( mock-up ) data showing the problem

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post