Re: $$Excel-Macros$$ paths between cells

2010-08-23 Thread n3wsgr0ups
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 Au

$$Excel-Macros$$ paths between cells

2010-08-22 Thread n3wsgr0ups
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