Hi

I have an applicaton that takes a selection of cells which should be a list
of numbers.

I use the SpecialCells function to ensure that i have a range which consists
of only numbers and no text strings.

I also want to ensure that all the strings are of a minimum length. I know
there is a range validation method and a textLength option that goes with it
but im not sure if it will do what i want it to. I cant find much info on
how to use it other than the 1 example on MSDN.

Anyone got any clues?

Thanks

BC