View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Biff Biff is offline
external usenet poster
 
Posts: 1,688
Default build a word search puzzle

Hi folks!

Anyone want to take a shot at this:

My mother LOVES to do word search puzzles.

Using Excel, I'm able to build the puzzle manually. Pretty
easy, no big deal. I manually plug the words into the grid
then I have a macro that fills the empty cells with random
letters.

I'm wondering if it's possible to have the words
automatically get plugged into the grid.

Say I have the list of words in a range, A1:A25. Then I
can run a macro to have the list of words randomly placed
into the grid.

Each word gets broken down so that 1 letter is in 1 cell
and of course the entire word must be in consecutive cells
in one of the below patterns.

The patterns can vary as some might know that are familiar
with word search puzzles.

The patterns can be:

horizontal left to right
horizontal right to left
vertical top to bottom
vertical bottom to top
diagonal top to bottom
diagonal bottom to top

I know this asking for a lot and is a tough one to do, but
if someone is willing to give it a go I'd really
appreciate it.

Thanks
Biff