View Single Post
  #21   Report Post  
Old November 29th 08, 06:33 PM posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
First recorded activity by ExcelBanter: Nov 2006
Posts: 15,768
Default alpha numeric data validation for excel

Microsoft Excel MVP

"T. Valko" wrote in message
"Harlan Grove" wrote in message
"T. Valko" wrote...
This seems to work:



Or avoiding the volatile INDIRECT function but taking advantage of
ASCII encoding,


Nice one, Harlan.

I should've realized we could use array constants rather than
ROW(INDIRECT(...)) since it's only a few characters.


I can't believe that between us we didn't catch this...

Can't use array constants in a DataValidationCustom rule.

Microsoft Excel MVP