numeric arguments to actions

  • Thread starter Thread starter Monte Milanuk
  • Start date Start date
M

Monte Milanuk

I'm starting to look at things like Monte Carlo simulations, etc. where
I would be say, copying a formula down a large number of cells, etc. Is
there some way to do this via a numeric argument so I can tell Excel to
copy this block of cells with formulae down to the next 5000 rows, etc.
Seems to be an area that 'click-n-drag' isn't quite as useful as one
would think...


Thanks,

Monte
 
hi, Monte Milanuk !
I'm starting to look at things like Monte Carlo simulations, etc. where I would be say, copying a formula down a large number of cells, etc.
Is there some way to do this via a numeric argument so I can tell Excel
to copy this block of cells with formulae down to the next 5000 rows, etc.
Seems to be an area that 'click-n-drag' isn't quite as useful as one would think...
Click to expand...

- copy the source cell/formula
- enter the range-destination in the "name box" (left side of the formula-bar)
- press enter (or paste) to paste in (selected) destination range

hth,
hector.
 
Back
Top