numeric arguments to actions

[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

 

[Héctor Miguel]

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...

- 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.