You should be able to run that macro as many times as desired without error.

If you already have code that you are using, perhaps posting the code and an example workbook that does not contain sensitive / personal data would assist in rectifying your issue.