Thanks for that,

It almost worked - unfortunately it pastes as "paste special" ->values
instead of copying the formulas from I6:W6 (my fault - I wasn't clear on that in my explanantion)

I'm assuming the code "Value = .Value " is doing this.
Can you advise?

Still, what you gave me was great - I would never have got there

Thanks,

peter_act