Hi Richard,

Thanks for the quick response. Unfortunately, as the base spreadsheet is a Pivot Table, it's preventing me from deleting the first 8 rows. I'm receiving the below error message when running the macro.

Is there a way to bypass this error and delete them anyway?

Error.PNG

Thanks,
Dom