bingo macro for non duplicate

How can I prevent duplicate numbers/pictures from one card to the next?

IE If B1 or an apple is on card one I do not want them on card 2 at all

Not entirely sure how you generate your card numbers/pictures but one way would be to keep a table of used numbers/pictures and check against this table every time you generate new cards and skip the number/pic if it is on the list.

Hi,

We really need to know what your rules are for generating cards. You say that if a picture is on card 1 you don;t want it in card 2, but clearly your example doesn't satisfy this rule. For instance both cards contain the purple VW Beetlse, Vulture, Rail Crossing pics. etc.

Look at this link. It is for a Seating Chart. Clearly this model could be adapted to bingo cards.

http://blog.contextures.com/archives...ng-with-excel/