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.