range limit
 

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

range limit
 

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" wrote in message
...
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

range limit
 

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" wrote:

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" wrote in message
...
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

range limit
 

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


"Atishoo" wrote in message
...
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" wrote:

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" wrote in message
...
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