Select the cell with the formula............say A1

In NameBox type A1:A1200 and ENTER

CTRL + d to copy down.


Gord Dibben MS Excel MVP

On Thu, 2 Oct 2008 11:55:03 -0700, Dave
wrote:

I want to copy a formula to a range that is 1200 cells down
is there a quick copy command to di it