Is there a way to get around the 256 character limitation on
validation text.

ok here is my problem:


IF I define a name range (testX) and that testX references more than
35 cells in another worksheet (sheet1) with over 20 characters of
data
in each cell (well over 256)


then I go to sheet2 put data validation on a Cell (validation
criteria allow: list; source =TestX) This shows me the entire list
of
data frm those 35 cells ( this is great).


However if I use a variable in a macro to populate the source it
limits me to 256 characters. Can someone tell me what I am doing
wrong?


Oh and I am very new to this, sorry if I have not explained it very
well hopefully someone can pick through this and understand what i am
trying to say.


Thanks.

>>However if I use a variable in a macro to populate the source it
limits me to 256 characters.

You might want to post the code that does this step just to clarify things.
Also show how you set the value of the 'variable'.

--
Jim
<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
| Is there a way to get around the 256 character limitation on
| validation text.
|
| ok here is my problem:
|
|
| IF I define a name range (testX) and that testX references more than
| 35 cells in another worksheet (sheet1) with over 20 characters of
| data
| in each cell (well over 256)
|
|
| then I go to sheet2 put data validation on a Cell (validation
| criteria allow: list; source =TestX) This shows me the entire list
| of
| data frm those 35 cells ( this is great).
|
|
| However if I use a variable in a macro to populate the source it
| limits me to 256 characters. Can someone tell me what I am doing
| wrong?
|
|
| Oh and I am very new to this, sorry if I have not explained it very
| well hopefully someone can pick through this and understand what i am
| trying to say.
|
|
| Thanks.
|