Edit and Array

J

JorgeAE

I am trying to edit an array in validation - custom screen but once is
done it returns to the its original settings. I would like to have the
modifications. Any suggestion?
 
W

William Horton

Look under Excel help for "Determine valid entries for a cell by using a
formula". Under the notes section it states that You cannot use array
constants in data restriction formulas.
 
Top