This worked perfectly!

So now that I have two working macros for this task, is there a way they can run together as one code or is it best to run the two macros separately?

Many, many thanks!