Hi!

I'm having some problems with my "name boxes". The thing is that I have combo boxes that change their values after the choices made in the previous combo boxes so too speak.

What I've done is to set name to some lists and use INDIRECT() in data validation... I guess you know what I mean...

However, the problem is that you can't name a list with a space in the name. For example you can't name a list "North America", it seems like it must be "NorthAmerica" instead. Is there a way to solve it!?!?

Sorry for my poor english

Thanks in advance

Jake