LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Sudoku Program Help

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Sudoku ernie Excel Discussion (Misc queries) 1 April 14th 10 04:45 AM
Sudoku Danny Lewis Excel Discussion (Misc queries) 1 August 1st 06 01:40 PM
Sudoku Jonathan Cooper Excel Discussion (Misc queries) 2 January 30th 06 10:31 PM
sudoku Wim Rijsdijk Excel Programming 2 August 1st 05 10:11 PM
sudoku Wim Rijsdijk Excel Programming 3 July 31st 05 10:38 PM


All times are GMT +1. The time now is 07:40 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"