Hi Mike

when i try entering
=$B$4:$E$4
i get a error message from data/validation
"you can not use a direct reference to a worksheet range in a data
validation formula"

do you get the same error?
what are you trying to achieve with this formula? the cell with the
validation on it must be equal to the sum of the four values in the range
or???

Cheers
JulieD


"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.