Thomas,

Thanks for the feedback, but it would be better to keep to the original
thread, it saves people from reading unnecessarily.

FWIW, I think my way is "better" as it rolls off the keyboard better, there
is no Union'ing going on, and it is the Excel (as against VB/VBA) accepted
way of declaring multiple ranges.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Jonsson" wrote in message
...
Hi guys,
As I have about 50 sheets to change,
I choosed to use the one that you suggested Bob, it was easier to copy and
paste AND IT WORKS!!

Thanks, you saved my day!!

//Thomas