EXCEL validation drop down boxes. 256 limit

[I_am_fitz]

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.

 

[Willy Denoyette [MVP]]

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.

Wrong NG, please post Excel related questions to one of the Excel NG
(microsft.public.excel or, microsft.public.excel.programming ...)

Willy.