Data Validation code too long

Hi All, we had a code in our data validaton (List) in "D" and it work well but we needed to add more code to it and I think it is to much for it to handel.

Our code that worked was;

Please Login or Register  to view this content.

We added this to it;

Please Login or Register  to view this content.

Or new code that will not work is;

Please Login or Register  to view this content.

Is there any way we can make this work? We would like a drop down list.

Hi Blacky1,

You should use named ranges of cells to do your validation. See http://www.contextures.com/xlNames01.html for a start.

Then read http://www.contextures.com/xlDataVal01.html and the links to examples on this page.

AND - Please click the green EDIT button below the above post and the "Go Advanced" and select the formulas in your post and click on the # icon to put code tags around them. It makes them a lot easier to read and use for us.