Kate,

You're welcome, but I don't think I'm going to be much help.

By "complete column," I mean I selected an entire column (clicked in the
column header). I did the same with a row in row 5, which, not
surprisingly, intersected the column. I also included the first 10
cells in another column, so there were two intersections. I don't know if
that mattered. I put the same Data Validation in these cells, then set up
the Validation, then used Edit - Go to, as we did. It didn't mess up as
yours did.

I also tried three cells. It worked OK. But then it sometimes does for you
too.

You might want to put on Office Service Pack 1. You never know. You can
send me the workbook if you want. I'll see if it fails on XL2002.
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Kate" wrote in message
...
Earl,
I don't know what you mean by this statement: "I included a complete
row, a complete column, and a partial column, overlapping"

What I do is select a single cell, then GoTo/Special/Data Validation/Same

and three cells get selected. Yet if I then choose Data/Validation I get
the error that the selection contains more than one type of validation.

This doesn't occur for all the cells in the sheet; for some, it works
correctly. I did an experiment: I copied a block of four cells containing
the three that got selected as having the same type of validation but
which then gave me the subsequent error, to a new sheet. It worked
correctly on the new sheet; no subsequent error with warning that all
validation would be removed if I proceeded. What could be going on here??

I'm using Excel 2003 SP1.

Thank you for persisting with this problem,
Kate


Earl Kiosterud wrote:
Kate,

You did say Same. I missed that. Ah-HYUK! (archaic for "Doh!")

I just tried a little test situation, but wasn't able to get such a
failure as you describe. GOTO correctly selected only the cells whose
Data Validation settings matched those of the active cell. I included a
complete row, a complete column, and a partial column, overlapping,
trying to confound it. Then with the cells selected from that GOTO,
Data - Validation did not indicate different settings -- it correctly
indicated the Data Validation settings. I'm using XL 2002.

Perhaps if you can describe your settings, the cells layout, we can see
if it will fail on our Excels. Also, indicate the release of Excel
you're using.

You might want to search the knowledge base at www.microsoft.com.