Use

=ak$7:ak$11

and copy across

--

HTH

Bob

"Going Crazy with excel"
wrote in message ...
I have developed a rule for a column of data.
=$ak$7:$ak$11
=$ak$4:$ak$6
I want to repeat this same rule to adjacent columns, AL thru AS.
Then I want to repeat the same rule for the range AK15 AK22 THRU
AS15 AS22.
Is there a way to repeat this same formula without re entering the same
formula throughout the entire workbook?
Any help would be greatly appreciated.