Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do i build a search table in excel | Excel Worksheet Functions | |||
build a search tool in excel | Excel Discussion (Misc queries) | |||
Build a search tool in excel | Excel Worksheet Functions | |||
Build a search tool in excel | Excel Discussion (Misc queries) | |||
need formula to search column for a word and return another word | Excel Discussion (Misc queries) |