without VB, you could number a predetermined set of rows. Then put your
formula into an 'if' statement that says if(currentrow<b2,formula,"")to keep
the cell blank. if you had the formulas already copied and in place, you
would see only blanks for the rows past the number you chose in b2.

"yshridhar" wrote:

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