Hi
make your range an Excel Table and correct your Macro accordingly
(BTW there is a VBA dedicated subforum on this forum)

__________________
Using O365 v2503 - 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