| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Validation lists
Is there a way to copy a validation list to multiple cells without the list
location changing, ie: a1:a12 changing to a2:a13 ect. Thanks Phil |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Validation lists
Before copying and pasting, make the validation list location $A$1:$A
$12 (not A1:A12). Hth, Merjet |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Validation lists
Cool thank you
"merjet" wrote in message oups.com... Before copying and pasting, make the validation list location $A$1:$A $12 (not A1:A12). Hth, Merjet |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Validation lists | Excel Worksheet Functions | |||
| How to clear validation lists based on other validation lists | Excel Discussion (Misc queries) | |||
| Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) | |||
| lists and validation | Excel Worksheet Functions | |||
| VBA and Validation Lists | Excel Programming | |||
Hybrid Mode
