Populate cells with two numbers only using vba <p>Please help me, what I am trying to do is to populate cells N2:N1041 with numbers 0 and 2. I want total of 100 cells (random cells to be filled in) in column N to be populated with "0" and the remaining 940 cells to have "2". Or in other words, I want the 9.6% of the range (N2:N1041) to be filled with "0" and the rest with "2".</p> <p>Thank you so much in advance. </p>