Hi,

Is it possible for excel in a selected set of cells, to place a letter (A, B, C or D) in each of the cells "randomly" so that at the end there is a total of 10 A's for example, 8B's, 9C's and 1D... overall?

Also, whenever anything is randomly generated in Excel, is there a way to stop the values refreshing to new values everytime the user clicks something?

Any help would be most appreciated,

Thanks.