Hi ,
for some strange reason the Data Validation - Cell Range function stopped working today.
When I click on the copy source button all is normal
Then when I click on the cell range the list is not populated.
Also if I do the basic =sum( , to start the function when I go to click on the cells to populate it the function just stops and i am put in the cell that I clicked on.
Is the a setting that I have changed that no longer allows the population of cells?
Cheers, Shayne