Yes i would like it to repeat down the worksheet as well.
Thanks

"Simon Lloyd" wrote:


If its single row then click your cell that contains the formula once
then hold shift and click the further most cell that you want the
formula in then goto EDITFILLRIGHT or did you want it repeating down
the sheet too?


--
Simon Lloyd

Regards,
Simon Lloyd
'www.thecodecage.com' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=26928