Data Validation Window?

  • Thread starter Thread starter Ken
  • Start date Start date
K

Ken

Excel 2000 ... I do not use Validation much, but usually
have no problem.

I used COPY/PASTE SPECIAL "Validation" to get Validation
into other cells ... Issue is ... the Validation Message
Window is now opening way off location from the PASTE TO
cells.

Above said ... if I select each cell & set Validation ...
Validation Window appears ajacent to cell where Validation
was set (perfect)... However, when I use COPY/PASTE
SPECIAL Validation ... the Window is appearing to stay
closer to the COPY FROM cell than the PASTE TO cell.

How do I fix this ... other than selecting each cell &
then setting Validation? ... Thanks ... Kha
 
If any data validation message is moved, all the messages appear in that
position.

To reset them, close then reopen the file.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

data validation 1
Preventing copy/paste on validated cells 2
Protect validation but allow drop down selection 1
If formula and Data Validation parallely 1
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
2007 data validation not working 1
Data Validation/Cell Protection Question 2
Data Validation Error 1

Back
Top