Just drag. Make sure you have absolutes where you want them $a$1:$a$100

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"dhstein" wrote in message
...
Is there any way to copy an array formula across and down in a range? Or
do
you have to "CTRL = Shift + Enter" each one ? Thanks for any help on
this.