Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can I limit cursor movement within specified range in excel? | Excel Discussion (Misc queries) | |||
Range limit for auto filter function | Excel Discussion (Misc queries) | |||
Range limit of CF | Excel Discussion (Misc queries) | |||
Limit cursor range | Excel Worksheet Functions | |||
Range name limit for data validation | Excel Worksheet Functions |