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