How change validation range for multiple cells

[somanyqs]

Basic one that I would think.
I have a column so perhaps 100 cells that all use the same validation list. And I have already made selections for all of those cells from the options within the validation range
Now (even though I have already made selections) I would like to increase the range of the validation list (so say from A1:A4 to A1:A8) but retain the selections already made.
I'm not sure how to change all 100 of those cells to the new validation range without wiping out all of the selections I have already made (just making a new validation range, then copying and pasting to the other 99 cells).

I've tried selecting all 100 cells, then making the change and selecting the checkbox 'Apply these changes to all other cells with the same settings'. And I've also tried changing just one of the 100 cells with that checkbox selected. I would have expected that to make the change, but no luck.

Using Excel for Mac 2011
Thanks all!

 

[Michael M]

Copy the range of selections and Paste somewehre else on the page
Recreate the DV list with the new names
Use 1 name and drag down as far as required
Now copy / paste the original selections back to where they should be !

 

[somanyqs]

Ahh thanks - I realized I needed to 'paste special - values' to get it to work. Thanks!

 

[Michael M]

Glad to help...