I$4

that is make the column relative, without the $

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"DEE" wrote in message
...
How can I automatically drag this formula into other columns?
Example: $I$4 1st column
$J$4 2nd column
$K$4 3rd Column
etc, etc........