This does not appear to work when the list of "nodes" is longer,
say closer to 2000.
Correct. Its constrained by the max number of cols available in the sheet
as you copy the formula in K2 across/fill down (ie 256* - 11 = 245)
*xl2003's max cols
You could try posting in .programming.
Or, use xl2007, which I heard has in excess of 2000 cols
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:362 Subscribers:64
xdemechanik
---