Hi...

My user must enter yes occasionally in a descending range
A1:A500. When yes has been entered cells B1:B500 must
return the date that the YES was entered in the
corresponding horizontal cell. This is similar to my
previous query but now dealing in ranges rather than
cells...nb the date must not change its value once the
date has been triggered by the 'yes'.

Many thanks to the clever guys...

GC