Did you use large ranges hat time ? Like A1:A65535 ? That would slow thing down
If necessary Dynamic ranges are best

__________________
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