ISREF Formula Function
Hello all,
I am using the ISREF in a cell validation it insure users are entering valid
range addresses. However, the ISREF is allowing invalid values. See example
below:
=ISREF(A:WW) = True
If you type this into a cell, Excel changes the "A:WW" to "A:DE".
Since I am using this in a cell validation, the actual cell value does not
change and the validation allows the incorrect data entry.
Does anyone know of solution/replacement formula I can use in my cell
validation.
Thanks for any help you can give me.
MSweetG222
|