Mark,
You're absolutely right!
I always tried to select the range, and you can't go to another sheet whan you're in the validation-formula-selecting-box (or how do you call that one).
Sorry, swst, to have "helped" you with my detour.
kind regards,
Erik