Whoops, sorry if I confused you. Love your idea though. I cant help feeling that there is some kind of maths technique using path analysis, but probably wouldnt understand it! i'm writing this to try and help solve hidato puzzles. Kishen, sorry I like the anonymity of group postings.
Steve On Aug 23, 10:47 am, Dave Bonallack <davebonall...@hotmail.com> wrote: > Hi, > > This is a tricky problem, made trickier by the fact that in paragraph 1 you > ask for blank cell paths, while in paragraph 2 you ask for non blank cell > paths. > > But which ever you want, the problem has the same level of difficulty. > > Supposing we want to find blank cell paths: > > Basically you need the code to do trial and error, and place all those trial > and error code sequences into Loops to minimze code length. > > Looking at the logic, the start cell can have up to 8 adjacent cells. > Probably using OFFSET, we would query each of these adjacent cells in a > pre-set way, perhaps starting straight above, and working around clockwise. > If the start cell was on the edge of the sheet, we'd have to skip some of the > 8, to prevent errors. Work around until we found a blank cell. Save that cell > address into a variable, then make it the subject of the next search. We > would have to check each cell to see if it was within the pre-defined range > before moving to it. We'd probably use INTERSECT for that. Each time we move > to a new cell, ask if it is the required Stop Point. Keep going until the > answer to that question is YES. That's one path. Record it somewhere, then > back to the first cell and start again, but this time the code must ignore > the 1st choice and look for a second, etc. If the path gets stuck at the edge > of the sheet or the edge of the pre-defined area, then that's no path. Back > up one step and continue around the previous cell, looking for another blank > cell. etc. > > It's fun to think about, but it would take quite a while to write - for me > anyway - so I'll have to leave it to you, or someone else with way too much > time on their hands. > > Regards - Dave. > > > Date: Sun, 22 Aug 2010 07:32:31 -0700 > > Subject: $$Excel-Macros$$ paths between cells > > From: stozs...@gmail.com > > To: excel-macros@googlegroups.com > > > Need you brains guys! > > > Suppose I have a defined range on my worksheet, and within that range > > I have numbers or blank cells. i'm trying to write some vba code that > > given 2 cells as a start and stop point, finds all the blank cell > > "paths" between those two numbers. > > > ie suppose 1 is at a1 and 5 is at c4 and the range is a1 to e6, i need > > to produce a list of non blank cell paths between the 1 and 5. a path > > being a way to traverse the cells between the two numbers by "walking" > > on non-blank cells including cells that touch at corners. > > > Thanks in anticipation. > > > -- > > ---------------------------------------------------------------------------------- > > Some important links for excel users: > > 1. Follow us on TWITTER for tips tricks and links > > :http://twitter.com/exceldailytip > > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > > To post to this group, send email to excel-macros@googlegroups.com > > > <><><><><><><><><><><><><><><><><><><><><><> > > HELP US GROW !! > > > We reach over 7000 subscribers worldwide and receive many nice notes about > > the learning and support from the group.Let friends and co-workers know > > they can subscribe to group > > athttp://groups.google.com/group/excel-macros/subscribe -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
