Hi Robert,
Extend formulas and formats works as advertised it's just that are so many
little things that can break the chain, like empty spots (cells) on a row.

"JRB" wrote in message...
Thanks David, will give the macro route a try. Pity extend formulas does not
work as advertised, it seems a pretty useful idea.
Robert