range limit

[Atishoo]

Hi
Im programming a series of combo boxes to appear given the active cell
falling within a specified range.

im pre defining the ranges by selecting the individual cells (non of which
are adjacent) placing a name in the name box then return.

the problem is that when i reselect the range it has only selected the first
38 cells and no more! is excell limited to 38 seperate cells per range?? how
can I get round this? its irritating the t*** off me now

 

[Bernie Deitrick]

Is there a pattern to you cell selection? or is it fairly random? Perhaps there is other logic that
can be applied.

Bernie
MS Excel MVP

 

[Atishoo]

Hi yes the cells are every other cell in both x and y across 4 given ranges
(upper left upper right lower left and lower right) then every other cell in
3 vertical strips again in 4 given ranges so they do fit a pattern

 

[Bernie Deitrick]

Give an example with cell addresses, if you could. What extent of cells.... Every other cell in both
x and y is a bit ambiguous...

Bernie
MS Excel MVP