Nick -

It depends on whether you care to retain the original data and on how easily
you want the changes to be made. I'd use the dual ranges. Worksheet space is
cheap, human labor to recreate something that you've overwritten is not.

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/

Advanced Excel Conference - June 17-18 2009 - Charting and Programming
http://peltiertech.com/Training/2009...00906ACNJ.html
_______


"Nick H" wrote in message
...
Thanks Jon,

I had suspected this was the case but didn't want to give up hope
until an MVP confirmed it. ?;^)

I have about 200 series in rows so would need about 200 helper rows. I
may well do as you suggest with a helper 'range' but need to weigh up
the difference in speed between using VBA
(xlPasteSpecialOperationMultiply) and formulas.

Br, Nick H