Aha thats what "recursion" means!... slowly beginning to understand how it works on high level. Also the "macro recording" didn't know such function even exist.

Gotta admit my knowledge is very limited when it comes to coding and understanding all definitions surround it. its comparable to my English .-)

Anyway, your silver platter code is just beautiful :-) and ofcurse Kix is the king.

I realize that those few times I make codes I have problem with understanding the definition and use of "array". Thats something I always need to refresh, before I can make an script work...
It gets much more difficult when other language gets involved in the case scenario, like VBs, as I know nothing about it.

In our case here, I still have some wondering that I couldn't figure out.

You are using variables which I cannot figure out what they really represent and do, and how you get their values:

 Code:
$xlDown = -4121 
$xlToLeft = -4159 
$xlToRight = -4161 
$xlUp = -4162


I have played with macros in Excel. I of course need now to adapt your code to the Excel list I have (the big one), but found its not that easy as it looked in first place:

For adapting the code to the actual Excel list I change the following in the script:

 Code:
$Manager = $objExcel.Range("D"+$i).Text
$RC = $objExcel.Columns("D:D").Select

I changed "D" to "K" in these line, that is the column of managers


I changed "D" to "K", The original Excel list I have contains 14 columns (the last one is "N"). The first column "A" presents the User IDs, followed by lots of user contact information, and then column "K" represents the managers, followed by managers contact data.

its about 1000 users, and 50 managers. some few also don't have a managers assigned on them so for those the managers column is empty.

I'm going now to switch to excel 2003 instead of 2007, see if its easier to understand how i can benefit from macro recorder, maybe I succeeded adapt your code to the big Excel file.
_________________________
"... Great minds talk about idea' s, average minds talk about events and samll minds talks about people...!"