An apparatus and method is provided for preparing and using a very large and diverse array of compounds on a substrate having rapidly accessible locations. The substrate contains cells in which the compounds of the array are located. Surrounding the cells is a non-wetable surface that prevents the solution in one cell from moving to adjacent cells. The compounds are delivered to the individual cells of the array by a micropipette attached to an X-Y translation stage.