Incidental wrote:

I'm not sure if you can apply a value to a whole range without
iterating through it but the code below will do what you want

If done on the same sheet, you can apply a value to a whole range. So
this is something that happens only when you try apply it on another
sheet. But thanks for the solution. I'll try that.

Gustaf