View Single Post
  #1   Report Post  
Jamesmor
 
Posts: n/a
Default list box using defined name

I went through the directions for creating a "named" list (went to
insert-name-define-added cells-clicked add-clicked close)

I named my list "testname"

I go to the cell I want to be a list box, then do the following
-data-validation-allow list-type "=testname" - click ok

I get an error message, is there something I'm doing wrong?