Thank you Sandy. The formula works but not my problem. I have to copy down
the formulae upto J1000. As these are array formulae it is taking some time
to finish the calculation. What i want is a procedure that removes the
formulae first from A7:J (previous copy range), and copies the formulae of
A6:j6 down the value in B1. Any suggestions pls.
Thank you once again Sandy for your formula.
Regards
Sridhar


"Sandy Mann" wrote:

If you mean for example with 6 in B1, for the 5 rows below A6:J6 to show a
result of a formula then enter in A7:J7 a formula like:

=IF(ROW()-6<$B$1,<Your formula,"")

and copy down as far as you will ever need. The formulas will only show
down as far ar the number of rows sprecified in B1.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"yshridhar" wrote in message
...
Is there any procedure to copy down a range of formulae (say A6:J6) based
on
a cell value (b2)? I have formulae on a6:j6. I would like to copy down
them
upto the value that is entered in b2.
Thank you all
Sridhar