Hi

=OFFSET($B$1,COLUMN()-1,0,1,4
returns:
B1:E1 for column A
B2:E2 for column B
B3:E3 for column C etc.


--
Arvi Laanemets
(When sending e-mail, use address arvil<Attarkon.ee)



"Mike Peter" <Mike wrote in message
...
I need to enter a formula using Data Validation. The formula is
"=$B$4:$E$4".
How do I change this formula to use the Column() function instead of
constant
'4'.

I want it to get the number '4' using current Column(). The formula has to
look like "=$B$(Column()):$E$(Column())". But the data validation dialog's
'Source' input box refuses to accept this as valid formula. Is there any
work
around? thanks.