Strange copy / paste special -> Data Validation behaviour

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

AA Arens - 30 Dec 2006 16:04 GMT

I am a fan of Data Validation, but tonight was disturbing.

I use =IF($C7<>"",hours). This a valid statement and can be used for
both "list" option as "custom".
(hours = defined name of a range of values)

It works for that cell

BUT

If I copy the cell and pull the mouse over the cells under this cell
and paste Special > Validation them I expected to far that the $C7 will
change into $C8, $C9 etc. but it remains $C7.

How come?

Bart
Excell 2003

Reply to this Message

Peo Sjoblom - 30 Dec 2006 19:36 GMT

It certainly changes for me if I use your formula

Signature

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)

>I am a fan of Data Validation, but tonight was disturbing.
>
[quoted text clipped - 14 lines]
> Bart
> Excell 2003

Reply to this Message

Debra Dalgleish - 30 Dec 2006 20:38 GMT

Is that the exact formula you used? It shouldn't work if you selected
Allow:List, unless you include a list for the value_if_false argument, e.g.

=IF($C7<>"",hours,other_list)

> I am a fan of Data Validation, but tonight was disturbing.
>
[quoted text clipped - 14 lines]
> Bart
> Excell 2003

Signature

Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Reply to this Message

Rate this thread: