dertermining if one or more of value in column

[gwithey]

Does anyone know why this code does not select the range specified

Please Login or Register  to view this content.

Im trying to look through a column and if it contains more than one probe name a cell "All probes".

Otherwise it should show the probe name.

I think im on the right lines does anyone know how this would work

George

[tinyjack]

Could you try to explain again what you want this code to do?

Also, you should note that a For Each loop is not changing the ActiveCell, so ActiveCell.Offset(-1,0) is going to be looking at the same cell in each pass of the loop.

TJ