| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Validation length, Range length
You're welcome!
-- Biff Microsoft Excel MVP "I think I need to rephrase the question" osoft.com wrote in message ... I tested the validation and came up with the same row number. The range size is handy to know for my data referencing. Thanks for the information. "T. Valko" wrote: A data validation list can contain up to 32,767 items. and limit to the number of rows and columns in a range? If you mean the size of a referenced range there is no limit (although there are some limits imposed by certain functions and formula usage). See this: http://support.microsoft.com/kb/166342 -- Biff Microsoft Excel MVP "I think I need to rephrase the question" osoft.com wrote in message ... Can anybody tell me the limits on the number of rows available for a validation list and limit to the number of rows and columns in a range? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Validation, Need text any length no spaces | Excel Discussion (Misc queries) | |||
| Problem with length of validation list in Excel 2002 | Excel Worksheet Functions | |||
| Validation - no dups and text length requirement | Excel Worksheet Functions | |||
| Variable series length/range | Charts and Charting in Excel | |||
| Data Validation List Length | Excel Worksheet Functions | |||
Hybrid Mode
