paths between cells

N

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 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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top