Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am trying to use excel to help solve the big SuperSudoku puzzles for
myself. I am OK with the algorythm but am not sure of the best way to implement the code to carry out each stage of the process. In particular I want a grid of six cells to be highlighted each time a selection change takes place. Each of the sixteen cells represent the possible candidates for the unique symbol that shall take their place. These will be eliminated and the sixteen cells merged to contain the correct symbol. This is a section of what I mean as an example. 0 1 2 3 0 1 2 3 4 0 1 2 3 4 5 6 7 4 5 6 7 4 5 6 7 8 9 A B 8 9 A B 8 9 A B C D E F C D E F C D E F 0 1 2 3 0 1 2 3 0 1 2 3 0 1 2 3 4 5 6 7 4 5 6 7 4 5 6 7 4 5 6 7 8 9 A B 8 9 A B 8 9 A B 8 9 A B C D E F C D E F C D E F C D E F 0 1 2 3 0 1 2 3 0 1 2 3 0 1 2 3 4 5 6 7 4 5 6 7 4 5 6 7 4 5 6 7 8 9 A B 8 9 A B 8 9 A B 8 9 A B C D E F C D E F C D E F C D E F Do I use the command myRange.Offset(+X,X) or just some other form of Range("A1:D4") to move the active range with the grid of 16 as shown? Any suggestions appreciated. Regards Gary |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel Sudoku | Excel Discussion (Misc queries) | |||
Sudoku | Excel Discussion (Misc queries) | |||
Sudoku | Excel Discussion (Misc queries) | |||
sudoku | Excel Programming | |||
sudoku | Excel Programming |